LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Excel Sheets Compiled to One Workbook

I have a program that currently creates three separate spreadsheets simultaneously during the experiment.  Is there a way I can create one file with the separate spreadsheets as worksheets in Excel?
 
Thanks.
LabVIEW 2016 - Windows 7

CLAD
0 Kudos
Message 1 of 2
(4,518 Views)

Look into the built-in example VI 'Write Table To XL.vi'. This VI opens an excel workbook, creates a new sheet and writes a table onto that sheet. You can use the 'Open Sheet' subvi multiple times to create new sheets and write your data into it. If your data already exists in other Excel files, you can simply use the 'Copy' and 'Paste' methods of the _Worksheet object right after you created the new sheet.

Does this answer your question?

Malosh

0 Kudos
Message 2 of 2
(4,511 Views)