Copying data to a named excel sheet

[ecrean]

Hi,

I want to copy data from a csv file to a named sheet in a .xls template file.   How do I do this?   I also like to copy data from a 2D array to a named

sheet in a xls file

[Puneet_K]

Use 'Write to Spreadsheet' VI for writing table into CSV File.

Have a look on the shipped example  \LabVIEW 2010\examples\office\Excel Reports.llb\Generate Report From Template (Excel).vi  to save table into excel template file.

Also see this link for more information. http://zone.ni.com/devzone/cda/pub/p/id/1339

[ecrean]

That won't work.  I have an excel file that has analysis and plots...after every measurement, we want to replace the raw data in the

excel file, which is one 1 worksheet, with the new data.  So I need to write into an exisitng xls file, and then re-save it to a new file name.

[ecrean · Accepted solution]

THis method works, but you first have to write to a csv file, and then read file in text format and append to report.

[Puneet_K]

Fine.