Open a text file as excel file

[Muthuraman]

Hi all,

I just want to show a text file (tab seperated) as an excel file. I just wanted to use the syst exec.vi for this. Anyone have any idea how to do it?

Your help is greatly appreciated.

Regards,

Muthuraman S

[MikeS81]

Hi Muthuraman S,

you can open the file with this "excel 'filename'", but it only opens the file, it'll not separate your data into different cells.

Mike

[parthabe]

Even if you want to show a txt file as an Excel file, the file extn needs to be changed to .xls by saving the original file as a copy & then opening it using the ActiveX Excel functions or the RG toolkit. It is better to save it as a .csv instead of a Tab delimited Excel file.

I m not sure how you are going to do this using the System Exec.vi.