Reading Data From Agilent 34401

[cnoyes23]

The left column is the loop iteration number.

[Gregory · Accepted solution]

Use the simple "Write to Spreadsheet" VIs. (They have a slightly different name in 2015). I have it set up for comma separated (.csv) but you can change the delimeter to whatever you want. This is a snippet so you can drag it onto the block diagram and play with the code.

[cnoyes23]

Thank you. This might be an overly simple question but what is a delimeter?

[cnoyes23]

Also would this structure still be valid if I'm trying to write multiple columns of data values for each loop iteration?

[Gregory]

Delimeter is what separates your data along a row.

Comma: Data1,Data2

Space: Data1 Data2

Tab: Data1     Data2

Yes, if you have another single data point for each loop you can expand the "build array" node and wire it in.

[cnoyes23]

For the pink box that says point, would you know what item that corresponds to? I'm looking for it but I can't find it.

[Gregory]

That's just a text header that I wrote to the file first. You can change the column, or expand the array horizontally, to change what text is written as a header.

[cnoyes23]

So does this write to excel or is this something I could also open in Notepad, for example (like the images I sent)?

[Gregory]

You can open .csv or .txt files in notepad. If you ever do want to write to an excel file, make sure to use the report generation toolkit, not the write to spreadsheet functions.

[cnoyes23]

Thanks for your help. The data is now nicely written in columns. One final question. The numbers only go to three decimal places. Is there an easy way to extend that?