Your code suggests that you do not understand the Report Generation Toolkit and have confused "Excel" with "Spreadsheet". Part of this is the confusion of having NI's "Write to Spreadsheet" VIs in the File Palette, which write CSV Files (or format data to be written in CSV format) and also the Report Generation Toolkit, which has "hooks" into Excel and actually writes .xlsx files.
Since you seem to know how to use the RGT, here's what I'd do:
- Remove all of the Write Spreadsheet functions (found on the File Palette).
- Outside the loop, issue the New Report and make it an Excel Report.
- Inside the loop, gather the data that you want to write into a 2D array (since that is what Easy Table requires). Now you have a choice -- you can either gather all of the data into one large(r) 2D array, and do one Excel Easy Table (with Header array and a single 2D Data Array), which you can do after you exit the loop, or you can write the Table one row at a time.
- Suppose you want to write one row at a time. Create a Shift Register to hold the Start coordinates (you'll see why in just a minute. You don't (yet) need the Report File Path -- you'll do the actual Save Report when you exit the loop. Also put the Array of Strings you want to use as a Row Header on a Shift Register (note -- "putting on a Shift Register" means you create a Shift Register and wire something to the outside to initialize the Shift Register). Also, of course, since you did the New Report outside the loop, bring the Report Object wire (looks like a green chain) into the loop, again on a Shift Register.
- Now, inside your loop, gather the 1D array of data that you want to write into the first row. You do not want to pass it through any string function, but want to keep it as a 1D array of Strings, or a 1D array of Numerics (whichever you prefer). Since Easy Table expects a 2D array, pass this 1D array through a Build Array function to turn it into a 1-row, N-Column 2D array.
- Wire your Easy Table function with the following: the Report Object Wire (from Shift Register), the Start location (from its Shift Register), your (now) 2D Data array (of a single row), the Error Line (of course), and (into the bottom connector) the Header from the Shift Register.
- Now wire the outputs to the corresponding Shift Registers, but do it carefully. Report Object is easy. There are two "next entry" outputs -- you want the first one, "Next row, bottom left" so that you write successive rows beneath each other. Error Out is easy. And for the remaining Shift Register, which was the Header, wire an empty Array of Strings (so you won't write headers on successive calls to this function).
- Finally, put the Save Report and Dispose Report functions (Dispose Report is what actually closes Excel -- you want to tell LabVIEW to close Excel rather than do it yourself, trust me on this) on the output side of the While loop.
Bob Schor
