Saving data in axcel file

[roy_daou]

Ok...

I'll save all my character strings in a 1D array and connect it to the "write to spreadsheet" outside the loop in order to save the header and within hte loop to save the numerival values of the DAQ...

In order to write to a new excel sheet for each simulation, how can I do it? (keep the same file but create a new excel sheet)?

Thank a lot

[lacVIEW]

ActiveX, see this forum thread here.

[smercurio_fc]

---

@roy_daou wrote:

In order to write to a new excel sheet for each simulation, how can I do it? (keep the same file but create a new excel sheet)?

Thank a lot

---

You never said that you had to write to an actual Excel workbook. The Write to Spreadsheet File only generates delimited text files. If you have to create workbooks then you need to buy the Report Generation Toolkit, or program Excel yourself using the Excel Object Model via ActiveX. There is an example that ships with LabVIEW that shows you how to write a table to Excel. There have been plenty of examples posted in this forum on Excel. There is also an Excel thread, which contains links to many examples. That thread also contains a user-written toolkit. NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD!