How to Read data From Excel File in Labview 8.5?

[Karthikeyan_Mathiyalagan]

We can read it from xls file, but it is encrypted..... we need exact data...

[MikeS81]

Hi KarthikeyanMathialagan,

can you please give us more informations? Maybe you can upload your code.

Mike

[Karthikeyan_Mathiyalagan]

i have attached that excel file...i want to extract the full data from that file..how i can read it...when i read by using "Read from spreadsheet file" function, data was in encrypted form....so please send me the correct way...

[waldemar.hersacher]

The "Read from spreadsheet file" can only read from text files in csv format not the format of Excel which is a MS properitary format.

Either you purchase the "Reporting toolkit for MS Office" or you program all the ActiveX stuff by your own. Be aware that you need to have Excel installed and licence on each machine your code is running.

[MikeS81]

Hi KarthikeyanMathialagan,

this should help you: http://zone.ni.com/devzone/cda/epd/p/id/2231.

Mike