How to read .csv file (from measurements)and read it in LabVIEW then automatically send to spreadsheet (excel) format?

[Jayd]

How to read .csv file (from measurements)and read it in LabVIEW then automatically send to spreadsheet (excel) format?

thx
Jay

[Dennis_Knutson]

The Read From Spreadsheet File function (on the File I/O palette) is for reading comma separated files. Just set the delimiter input to be a comma instead of a tab (\t). To write in Excel format, you need to use ActiveX. Look at the shipping example Write Table to XL and modify it, buy the Report Generation Toolkit, or search the forum and NI Zone for numerous example of Excel and ActiveX.

[Christopher Mitchell]

The attached VI (LV 6.1, Excel 2002) reads a CSV file into LabVIEW. You can use this VI with the 'Write Table to XL' example VI that comes with LabVIEW to translate your file.

[Jayd]

Hi Archmedes, thx for the vi.
Unfortunately, i could bot read it it;'s LV6.1, mine is 6.0
Any sugget how to cope with this?

cheers
Jay

[Venk7337]

Chris,

I have a block diagram that runs the equation but I need input values from .CSV excel file to do that. Attached is my block diagram diagram and CSV file..could anyone modify Block Diagram to get the data from .CSV file..

Thanks!

Luke

[Dennis_Knutson]

See original thread.

[Venk7337]

Dennis,

I've a question...Before writing the data to anXML file, is there a way to edit the tags in that file?

Thanks!