Write to Excel

[Dennis_Knutson · Accepted solution]

Of course you are getting only one value because that is what you are passing out of the while loop. You can enable auto-indexing to create an array but do NOT do this with dynamic data. Convert to something real such as a scalar inside the loop.

And please, since you are not writing an Excel file, do not use an xls extension.

[Bob_Schor]

I see from the code you posted that you are using NI's "Write to Spreadsheet" function.  What JeanLuc and I have been discussing is the Report Generator Toolkit in LabVIEW which works with Excel and reads/writes to Excel -- quite different.  I believe (but will admit I've never used it, nor am I likely to) that the Write to Spreadsheet function writes basically a text file that follows the .CSV (comma-separated values) format which Excel can read.  If that's the case, you could always "roll your own".  Alternatively, to accomplish your goal (which I believe is updating existing Spreadsheet files, either adding or replacing data), consider doing the following:

1. Read the existing file and save the data in a suitable data structure (say, an array).
2. Gather the new data, perhaps with DAQ Assistant.
3. Combine the new data and the existing data as appropriate (append, replace, whatever).
4. Write the combined data to a new file, or overwrite the old file.

Bob Schor

[crossrulz]

---

@Bob_Schor wrote:

I believe (but will admit I've never used it, nor am I likely to) that the Write to Spreadsheet function writes basically a text file that follows the .CSV (comma-separated values) format which Excel can read..

---

Not quite, but good enough for newbies to understand.  The Write To Spreadsheet File just writes a delimited text file.  By default, a tab is used as the delimiter.  I you save a file as a text file (*.txt) and open it in Excel, Excel will open it just fine.

[SparkEE]

Thanks to everyone, I appreciate all input.

Kudos to Jean and Dennis