create a vi to convert text tab to excel.

[Anu Mathew]

Hi..

I want to create a vi which converts the text tab file to .xls file. Can anyone help me to make this by sending a sample vi...

thanks,
Anu

[ThSa]

Hi,
you have several possibilities.
Either use the Report Generation Toolkit or look at this example

BR,
ThSa

[Kallis]

Hey Anu,

In case its a text file, just use the following VI. If you want a seperate desination, wire that path as the target path to the File copy VI.

Regards,

Kallis

[Joe_H]

You can write to excel an excel file in many ways but unless you are writing to excel using ActiveX in LV then you are just using a tab delimited text file that can be opened with excel, and all you are doing when you give it a .xls extension is forcing windows to open the file with excel it is not a true .xls file. You can do this with any file extension. If you really want it to be a true .xls file then use ActiveX and LV if it does not have be then just let it be a tab delimited file and give it some type of extension (made up if need be) and tell windows to associate this file with excel.

There are many examples and toolkits on the excel forum in the breakpoint.