error loading excel file

[Joven]

Dear All,

Can someone help in telling me what wrong with my loading of excel file from 2 different files? 1.xls file has no problem loading however 2-2.xls dont seem to load correctly.

I got the 2-2.xls from logging of parameters form data acqusition system. The attach is a small file. I need to load the file correctly first to plot the graph later.

Can anyone please tell me how to load it correctly?

[Joven]

Reattach the vi for lower version of Labview

[Dimitrios]

I am not sure what the problem is. If you try to open the 2-2.xls file with the notepad is coming up with funny charachters. To make it work what i did was open Excel copy your cells and then pasted them on a Notepad. Then i saved it as 3.xls and that seems to be working. But if you are creating that file when logging then you do something wrong over there.

Do you want to post the code where you create that file. I propably won't have the hardware to run it but i might spot what is wrong.

Have a look on the spreadsheet i have created below.

[newbieboy]

Dear dimitrios,

I think something is wrong with the .xls file. I have decided to save it in .txt file instead. while data logging After that, i have no problem with loading the file, i think it is a bit tricky to save it in xls format.

Thanks for your help.

[Dimitrios]

To be honest it shouldn't be that tricky, i have done that numerous times.

But if it does work as .txt that's fine then.

Kind Regards

[RavensFan]

Come on people. This question comes up several times a week.

Read and Write Spreadsheet File VI's DO NOT WORK ON EXCEL FILES.  They are only for text files that are formatted in a table like format.

Search for Read Spreadsheet File and Excel in the forums, then read the 100's of pages of messages about this.