LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to convert excel file to txt ?

i want to convert file excel to txt

0 Kudos
Message 1 of 14
(6,050 Views)

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


If Tetris has taught me anything, it's errors pile up and accomplishments disappear.
0 Kudos
Message 2 of 14
(6,046 Views)

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

0 Kudos
Message 3 of 14
(6,012 Views)

@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.

________/~~~~~~~~*********~~~~~~~~\________
Certified delinquent LabVIEW developer. Recertifying at next NI Days
Message 4 of 14
(6,008 Views)

I need of a Vi for convert excel file to txt

0 Kudos
Message 5 of 14
(6,016 Views)

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.

0 Kudos
Message 6 of 14
(6,007 Views)

I'm using labview 2015

0 Kudos
Message 7 of 14
(6,000 Views)

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

0 Kudos
Message 8 of 14
(5,992 Views)
0 Kudos
Message 9 of 14
(5,987 Views)

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.

0 Kudos
Message 10 of 14
(5,986 Views)