LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

File format to save excel

I have to create a new excel file by specifying it's directory path.I used the 'Worksheet' invoke node 'save as' method to do this.The file format should be specified. Could anyone share the file format number to save as excel file (.xls) in this way.. 

0 Kudos
Message 1 of 4
(2,385 Views)

It is so much easier to answer a technical question if you do us the courtesy of posting your code (meaning the VI, not a picture of part of the Block Diagram) so we can see what you are doing, and hence what you might be doing wrong.  We can also see what version of LabVIEW you are using.

 

When I want to write to Excel (meaning the Microsoft Office program, not what LabVIEW calls a "Spreadsheet file", which is really a text file in .csv format), I tend to use the Report Generation Toolkit which does almost all of the "heavy lifting" for me.  If I want to write a file with the .xls format, I supply a filename with that extension.  I can also choose to use the newer .xlsx format just by specifying that as part of the filename.

 

I can point to you an example that shows how to do this.  Go to the Search bar in the LabVIEW Forums and type Revised " (that's the word "Revised" followed by a space and a double-quote), wait, and choose the obvious entry (probably the first one).

 

Bob Schor

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

xlsx = 51
xlsm = 52
xlsb = 50
xls = 56

 

These are for windows - For MAC add 1 to each 

Regards

 

Ken

Message 3 of 4
(2,370 Views)

If you have to create Excel files on a machine without Excel installed, you can use XLR8 toolkit, in VIPM. Low cost, efficient. Prefer XLSX file format.

Regards

Message 4 of 4
(2,360 Views)