The title of your post is LabVIEW to Excel. If you want to write to Excel, you should use the Report Generation Toolkit, which is extremely easy to use (there are numerous discussions and examples in the Forums).
As a general rule, if you want to (a) learn LabVIEW and (b) use LabVIEW to do anything other than the most trivial demonstration of a simple task, then try to follow these two simple steps:
- Avoid all Express VIs. These usually oversimplify what can be done, and "hide" possibilities from the User, making it much more difficult to "untangle" the results.
- Avoid "Dynamic Data" wires (which are rarely produced or use except by Express VIs).
In particular, this means that to do the Excel writing you mention, you need to use the RGT and the following four functions:
- New Report, to create the Report Generation Object and link it to Excel. You do this once, before entering the loop to generate values.
- Excel Easy Table VI to write data into the Excel Worksheet. Depending on your needs, i.e. if you want to write all of the rows (and a single header) at once when they are all generated, or write just the Header, then each row, one at a time, as it is generated, you will place this call within the data-genating loop or after it. [If you want to write one row at a time + have a header row, you can write the header first, before entering the loop].
- Save Report to File and Dispose Report to save the file as an .xls or .xlsx file and to close Excel.
As I noted, there are numerous examples of code that does this, both in the Forums and in the LabVIEW Help. I posted a revision of one of the LabVIEW Help Examples here in January, 2014.
Bob Schor
