Virus scan in progress. Please wait to download attachments.
This example generates a 2D array of random data and then writes it to an Excel document using the Report Generation Toolkit; this example writes multiple times to the same Excel document.
When writing to Excel, the Report Generation Toolkit usually waits for all of the data to arrive before performing a write. In some applications it is more appropriate to write to a spreadsheet multiple times rather then waiting for all the data to arrive. This example demonstrates how to write to an Excel spreadsheet multiple times in the same VI (via a while loop). This example also prevents data from being overwritten/erased by successive writes.
The VI checks if the document already exists. If not, it creates it and uses the Save Report to File VI. If it does exist, it saves using the Dispose Report VI with the Save Changes input set to True. Save Report to File VI is only used with new files.