Reading spreadsheet

[pritam]

I am trying to reas an MS Excel file using "Read From Spreadsheet File (string).vi". But could not read. See the attached image for output givrn by "Read From Spreadsheet File (string).vi".

[Mathan]

Could you please show the screenshot of your excel file?

Thanks,

Mathan

[RavensFan]

You cannot open an Excel file using the Read from Spreadsheet file function.  That function can only open text files.

In order to read a true Excel file, you will have to use ActiveX functions.

If you had searched the forums on this topic, you would have found hundreds to thousands of messages discussing this very fact.

[MattBradley]

One easy way to read an Excel file is to save it as a csv file and then you can use the Read from Spreadsheet file function with the delimeter set to ",".

Like Ravens said, lots of examples can be found.

[pritam · Accepted solution]

Thanks all of you. I could read the excel fime using excel specific VIs in report generation toolkit. find the code attached.

[sonik1428]

Hello everyone!!

I have opened my spreadsheet as txt file. I need to start a loop only after data has been read from the file and not when the program starts. How do I do that?

Thanks

[ChrissyC]

Hi,

You really should start a new thread instead of posting to a three year old one (that isn't really that relevant to your question!).

To answer your question - you need to understand the basics of dataflow programming. Read the labview basics and you'll see how easy this is.

Simply use the error wire / reference wire from your file read and connect it to your to your loop - therefore the loop will only start when your file read has finished.

-CC

[Markanbl]

Hello, 

I have a similar problem with reading from spreadsheet. I have a .csv file that I try to read but I only get zerosin my array. I'll attach the .csv file and .vi as well if anyone is willing to take a look. All of the examples I've found have the exact same thing I have in my code, still I can't read the file properly...

 EDIT: Actually, it's okay, I solved my problem. I used Matlab to create the .csv file and I just tried creating a new blank .csv with copied data and now it works...