Open CSV files in Excel through labview

[Massif]

   Dear,

Am not famillar with *.csv files but I would like to know if it's possible to : open a CSV files in excel through labview.

I can't used ActiveX for my application. This application is on Labview 8.2

Regards

  Massif

[smercurio_fc]

CSV files are just comma-delimited text files, and you can just use the regular File I/O functions to read the files into LabVIEW, like Read From Spreadsheet File. Just specify the delimiter as a comma.

[lmtis]

Hi Massif,

a .csv file is a spreadsheet file, so use the "open spreadsheet file" VI.

Cheers

Edit:
Dang, I'm always 30seconds behind you smercurrio!


Message Edited by lmtis on 04-22-2008 10:27 AM

[Massif]

Dear Imtis and Smercurrio,

Thank you for your response but I have an other need.
I have to redonne my question:

I would like open a CSV file into Excel. But I would like control this opennig with Labview.
   Massif

[smercurio_fc]

In that case, since you don't want to use ActiveX you will need to use the System Exec VI to launch Excel and pass it the CSV file as an argument. For example:

Note that your path to Excel will vary depending on which version you have installed.


Message Edited by smercurio_fc on 04-22-2008 11:26 AM

[jaychisiang]

Dear smercurio_fc,

Thanks for your help. This solution is working and we solve the problem. 😃

[Bob_Schor]

If you have the Report Generation Toolkit, you can also use that to open a CSV file in Excel.  Here is a little test routine that (a) generates a CSV file using LabVIEW's Write Delimited Spreadsheet (renamed in LabVIEW 2015 and given proper Error connectors), reads the just-created file using Read Delimited Spreadsheet, then reads the same file with Excel using the RGT, and finally does a LabVIEW comparison of the two data arrays to verify that they are, in fact, identical.  Note that if you actually examine the "all rows" and "data" outputs, they will appear to be different, but that's just due to the default formatting of the respective indicators.

Bob Schor