06-16-2011 02:46 PM
Im working on a project that requires a workbook with all the raw and calculated data merged into one excel workbook. Currently I have all the sheets saved separately but for the life of me can't figure anything out from the examples i've seen so far. How would I Initially go about doing this?
06-17-2011 03:52 PM
Hi SnowLeopard,
Take a look at this post and see if it helps you get started in the right direction:
http://forums.ni.com/t5/LabVIEW/Multiple-Excel-Sheets-Compiled-to-One-Workbook/td-p/259560
Have a great day,
Chris V
06-17-2011 04:06 PM - edited 06-17-2011 04:07 PM
Why save the spreadsheets separately? Can you combine them from the gitgo using the Report Generation toolkit. How are you collecting the data? Is the data entry done manually or is it automated? From your post, it seems you collect the data by some other means other than with LV, but you want to merge the data with LV, correct?
Take a look at the example finder if you haven't done so.
04-30-2014 03:37 AM
HIi MoReese,
I intend to resurrect this old post as I am kind of stumble upon same thing,
I know how to generate excel reports with multiple sheets but I am in circumstances where its not possible to do so. This leads me to have multiple workbooks(being certain its 6) having 1 sheet each. Now I want all of them to combine into one workbook. Is such things possibe using labview ??
Your help will be truly appreciated.:)
04-30-2014 07:58 AM
With RGT you can create one excel workbook with multiple sheets. Do you have RGT? If not, you can use Active X to create/manipulate the spreadsheets; although, this will take a bit more work. With existing spreadsheets, you can copy the contents into a 2-D array and move them into the main spreadsheet. This is one way to do it.
05-03-2014 12:08 AM
Yes I do have RGT.Reading spreadsheets and appending it is not an option to me as of its too large to hold up in memory.
05-04-2014 11:58 PM