how to convert excel file to txt ?

[Felipe3109]

i want to convert file excel to txt

[jwscs]

you go into excel and save as csv (comma separated value)... this is a txt file, you just have to ignore the extension

[Felipe3109]

thanks for your help, but I need of a VI in Labview

[szewczak]

---

@Felipe3109 wrote:

thanks for your help, but I need of a VI in Labview

---

This is the kind of descriptive information you should include in an original post. Remember you are asking other people to solve your problem for you. This works because you leave behind breadcrumbs for other people to search/read/use in the future. 

For example, a well stated and answered post has Previously answered this. Because they were detailed in what they wrote back then, it is easy to search for their solution today.

[Felipe3109]

I need of a Vi for convert excel file to txt

[Gregory]

Please post what you have tried so far. What version of LabVIEW are you using? I think after 2012 or so the report generation toolkit was included with LabVIEW, which makes it relatively easy to work with Excel files. It does require that you have Excel installed on your computer to work with Excel files.

You would use report generation toolkit (search for it in the functions pallet) to create a new Excel report, with the Excel file you want to convert as the "template" input. (It's a little counter intuitive). Then you can use a read data or get data function to read the text from it, and use your choice of however you want to write it to a text file.

[Felipe3109]

I'm using labview 2015

[Gregory]

Great! Give it a go and report back with any troubles.

[Gregory]

Duplicate Post: https://forums.ni.com/t5/LabVIEW/how-to-convert-excel-file-to-txt/m-p/3801167#M1072793

Let's carry on our conversation over there.

[Gregory]

I did not realize I was posting on a duplicate post before, so here is a copy of my response:

Please post what you have tried so far. What version of LabVIEW are you using? I think after 2012 or so the report generation toolkit was included with LabVIEW, which makes it relatively easy to work with Excel files. It does require that you have Excel installed on your computer to work with Excel files.

You would use report generation toolkit (search for it in the functions pallet) to create a new Excel report, with the Excel file you want to convert as the "template" input. (It's a little counter intuitive). Then you can use a read data or get data function to read the text from it, and use your choice of however you want to write it to a text file.

[Gregory]

Please post what you have tried so far. What version of LabVIEW are you using? I think after 2012 or so the report generation toolkit was included with LabVIEW, which makes it relatively easy to work with Excel files. It does require that you have Excel installed on your computer to work with Excel files.

You would use report generation toolkit (search for it in the functions pallet) to create a new Excel report, with the Excel file you want to convert as the "template" input. (It's a little counter intuitive). Then you can use a read data or get data function to read the text from it, and use your choice of however you want to write it to a text file.