Writing data to multiple pages of spreadsheet

[VeeJay]

Hi There,

Is it possible to create a file with multiple pages like a spreadsheet so that I can write data from different states in different pages? For eg. I want Speed data on page 1, Timing data on page 2 etc.

Thanks!

V

[altenbach]

You can do whatever you want. A "spreadsheet" in LabVIEW is just plain ASCII, with tabs (by default) separating columns and linefeeds separating rows. In the end, it is just a long plain string.

You can easily use a couple of "array to spreadsheet string" operations and concatenate them all whle interlacing formfeed characters. At the end, write the resulting string to a file.

[Wart]

If you mean specific worksheets of an excel file I think you need the report generation toolkit to handle that.

Take a look at: http://zone.ni.com/reference/en-XX/help/370274E-01/lvoffice/excel_add_worksheet/ as an example.