LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

READING EXCEL SHEET WITHOUT ACTIVEX

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.
0 Kudos
Message 1 of 5
(2,854 Views)
Function\File IO\Read From Spread Sheet File.vi
 
Joey
CLD
0 Kudos
Message 2 of 5
(2,846 Views)

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.

0 Kudos
Message 3 of 5
(2,842 Views)

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

0 Kudos
Message 4 of 5
(2,834 Views)

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

Retired Senior Automation Systems Architect with Data Science Automation LabVIEW Champion Knight of NI and Prepper LinkedIn Profile YouTube Channel
0 Kudos
Message 5 of 5
(2,829 Views)