READING EXCEL SHEET WITHOUT ACTIVEX

[tchaou]

Hi,

I want to know if is it possible to read an excel sheet in labview without  activex control. The application which i work on is design to be targeted to the CVS which doesn't support ActiveX control. so i got to find a pass of doing that. Can someone help me with this issue?

Best Regards,

Tchaou.

[joeycao]

Function\File IO\Read From Spread Sheet File.vi

Joey

CLD

[Marc_A]

Joey that will only work if the file is simply a text file of data separated by a delimeter. A file saved in Excel is not. Excel files contain formatting, if you open one up with notepad you will see gibberish.

I'm not really sure how you can read an xls file without ActiveX, but I didn't want you to get wrong information.

[joeycao]

Yeah I am glad you corrected me, I got mislead by the window ICON when I try to give it a .xls extension.  Just shows I have so much more to learn, thanks.

-Joey

[Ben]

Joey's suggestion is the only "legal" method of doing this without ActiveX (as far as I know).

To write the file directly to an XLS format would first require reverse engineering the XLS format which I believe violates the End User License Agreement that comes with MS stuff.

Ben