Combining multiple spreadsheets into one workbook with excel

[SnowLeopard]

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?

[Chris V]

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

[MoReese]

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.

[jatinpatel1489@gmail.com]

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.:)

[MoReese]

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.

[jatinpatel1489@gmail.com]

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. 

[srikrishnaNF]

Hi jatinpatel1489,

   Without copying the data from an excel sheet and merging that excel sheet to another workbook is not possible.

Regards,

SrikrishnaNF