excel

[lapig00]

hi guys

i wanna read excel in labview

but when i set automation refnum，i cant find excel....

what's this problem?

Hope anyone help me !!!

thanks

[ben64]

You have to use Microsoft Excel 14.0 Object Library Version 1.7 (version may be different on your PC)

Ben64

[lapig00]

but i dont have microsoft excel 14.0 Object Library Version 1.7 too...

[ben64]

You can try to repair the Office installation. If you have the Starter version you cannot use ActiveX to control it. You can also try to find the library on the MSDN web site and install it, check what is the recommended library version for your Office version.

Ben64

[lapig00]

ok

but what should i look for file in msdn?

if i want to repair my office

can u give me it's name?

thanks u reply me

[Bob_Schor]

• What version of Windows are you running?
• What version of Microsoft Office are you running?
• What version of LabVIEW are you running?
• Are you running Student, Full, or Professional Version of LabVIEW?
• Do you really want to read .xls or .xlsx files, or are you trying to read what LabVIEW calls Spreadsheet Files (.csv format)?

You seem to be doing something slightly non-standard ...

Bob Schor

[lapig00]

oh sorry this is my bad!!

my windows version is win10

my office version is 2013

my labview version is 2015 and it is student's version

and i  wanna read excel's xls file.

ps:I just want to practice how to read excel in labview.

And thanks you for your reply 

[Bob_Schor]

With the Student Edition of LabVIEW 2015, you do not get access to the Report Generation Toolkit for Microsoft Office, which offers NI's "hooks" into Excel and Word.  There are other toolkits you can purchase, but if your goal is to "practice how to read Excel in LabVIEW", you may be in for either purchasing additional software or spending a lot of effort that may detract from the experience of learning and working with LabVIEW.

Bob Schor

[lapig00]

omg  so i wanna practice it

i must to buy else tookit...

ok i try to read txt file  to finish my practice...

thanks u for ur reply~~~

[Bob_Schor]

If you want "Spreadsheet Lite", try LabVIEW's Read/Write Delimited Spreadsheet functions.  These write Comma-Separated Variable Files (with extension .csv), files that typically show an "Excel-like" icon, as Excel knows how to read and write this particular form of pure text file.

The idea of reading/writing Excel ("true" Excel) is getting your data organized in row/column format, and deciding whether or not you want row and/or column headers.  You can do exactly the same thing with the Delimited Spreadsheet functions (they are found on the File I/O Palette in LabVIEW 2015, possibly the first two functions).

Bob Schor