LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

replace excel file and close

Does anyone know how to replace an existing excel file without having to open the excel program?
I want to write data into the excel without having to open the excel program.
 
Thank you
-bm-
 
0 Kudos
Message 1 of 3
(2,432 Views)
The only way you can do this is to write it to a spreadsheet file and give it the extension .csv or .xls so that excel will open it directly, otherwise just write it to excel but do not make it visible.



Joe.
"NOTHING IS EVER EASY"
0 Kudos
Message 2 of 3
(2,427 Views)
Bus,
You can also use the write to "spreadsheet file.vi" and set the append parameter to false. If you specify a file that already exists, a dialog box will appear asking if you want to overwrite. Saying yes will overwrite the file. This process will allow you to replace an excel file without ever having opened excel.
 
Best Regards
 
Chris C
Applications Engineering
National Instruments
Message 3 of 3
(2,407 Views)