LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I open Excel file containing text in LabVIEW

Hi,

I have created new excel with some text. And when I am reading with LabVIEW, it showing garbage. If I save excel file with txt option, I am getting proper data in Excel. Is there any way to avoid save with txt option.

Do any body have any vi to support issue.

Thanks
0 Kudos
Message 1 of 3
(2,818 Views)
If you save a excel file as a txt you can read it with read characters from file.
I'd made you a sample that converts a excel file saved in txt into a matrix.
0 Kudos
Message 2 of 3
(2,809 Views)
If you want to read directly from the Excel file format, without saving it as text, you'll have to use ActiveX.

Have a look through the examples (Help menu, then Find Examples) and search for ActiveX. There are several examples that should help you get started.

Ed


Ed Dickens - Certified LabVIEW Architect
Lockheed Martin Space
Using the Abort button to stop your VI is like using a tree to stop your car. It works, but there may be consequences.
0 Kudos
Message 3 of 3
(2,802 Views)