LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Add worksheet in Excel

Hi is there any option for adding new worksheet while using the Spreed sheet write VI in file I/O?
-----

The best solution is the one you find it by yourself
0 Kudos
Message 1 of 2
(2,387 Views)

No.

 

Write to Spreadsheet file has nothing to do with Excel.  It creates a text file in a tabulated format that Excel is capable of reading by way of its import functions.  There is no concept of sheets in a text file.

 

If you want to work with Excel and multiple sheets, you can't use the Write to Spreadsheet File function.  You will have to use ActiveX commands.  Search this message thread for links to other messages that discuss programming Excel with ActiveX.  Excel Board

0 Kudos
Message 2 of 2
(2,380 Views)