LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

inputting data into an excel file

i need to input data into a file.... now when i use the "write (or read) to spreadsheed file.vi" i get a blank page unless the file is a text file and not a spreadsheet file... how do i do it so that i can write to an actual SPREADSHEET file... thank you
0 Kudos
Message 1 of 2
(2,757 Views)

Write to Spreadsheet can only create a text file with (typically) comma or tab separated data. A spreadsheet file is a generic term. All spreadsheets are not Excel. All spreadsheet programs are capable of importing comma or tab separated data. If you want the ability to automatically open Excel by double clicking a file you create, just save the file with extension .csv. I don't think saving a text file with the extension .xls will work. If you really need to create an Excel file with all of the extra bells and whistles that go with that, then you have to use ActiveX. There is the shipping examples called Write Table To Excel. There is also the add-on LabVIEW Report Generation Toolkit for Microsoft Office. There have also been hundreds of postings to this forum with Excel as the subject. Many of those have example code. Do a search and I think you'll find what you need.

Message 2 of 2
(2,757 Views)