Can Labview read SYLK files

[mattias@hv]

Hi!

I have a lot of SYLK-formatted files (http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)). I need to convert these to simple text file format. Have someone here managed to load SYLK-files into Labview using the "Read from Speadsheet file"-function? I have search the forums but without any success.

Thanks in advance.

/Mattias

[MikeS81]

Hi Mattias,

you can open your SYLK files with excel and store it as a *.csv file. The CSV file can be simple read with the "Read from Spreadsheet file" function.

Is this an option for you, or do you want to write your own SYLK interpreter?

Mike

[mattias@hv]

Thanks for your quick reply. You are fully right, one could open the file in Excel and save as *.csv. However, since my customer has 1000+ of these files I would like to automate this process. I guess I will have to write my own code for transforming the file from slk into csv.

I will make sure they save into csv directly next time.

Regards, Mattias

[GerdW]

Hi Mattias,

you can control Excel from LabView (via ActiveX).

So you don't need your own converter, just a small vi to control Excel - might be much less work

[mattias@hv]

Excellent! Why didnt I think about that?! 🙂

Thank you!

/Mattias

[smercurio_fc]

Actually, in this case I think it will be cleaner to write a macro in Excel. You can convert the files from within Excel using the macro and then save them as .csv. It will likely run a whole lot faster than trying to automate Excel via ActiveX.