Is it possible to read data from a .xlsm file in LV 8.5.1 WITHOUT USING a report genration toolkit.

[sharmasargam9@gmail.com]

I want to read data directly from .xlsm files using activex. I donot want to convet the files to .xls.

Can you please tell if its possible to read data from .xlsm in version 8.5.1 ?

Will it be mandatory to buy report generation toolkit or is there an alternavtive way to do it.

Please help !!!

[GerdW · Accepted solution]

Hi sharmasargam,

yes, that's possible without buying RGT! (Just joking: You might buy XLR8 toolkit instead :D)

Use just ActiveX nodes to interact with Excel.

Search the forum for "Excel LabVIEW ActiveX" and you will find a lot of example VIs…

[sharmasargam9@gmail.com]

Hie 

First of all thanks a lot for your reply. I have a program in which i am reading the data from .xls format but when i use it to read .xlsm format it shows error. Can yoi suggest what to do. 

[GerdW]

Hi sharmasargam,

I have a program in which i am reading the data from .xls format but when i use it to read .xlsm format it shows error.

So little information…

Which "program" do you use?

How do you read this XLS files? (Using which functions?)

Which error do you get when reading XLSM files instead?

You need to (learn to) provide enough information to allow us to help you!

[sharmasargam9@gmail.com]

Okk thank you ! 

I am sorry for that. I will provide the entire information by tomorrow. hope to get a reply from you Tomorrow 🙂

[aputman]

Well, there is another way.  If you rename the XLSX to ZIP, you can see the underlying data and how it is stored.  The data from an Excel sheet is stored in XML format.  It should be fairly simple to read in the XML file and do what you will with it. 

[sharmasargam9@gmail.com]

I have attached the zip file which has the .xlsm file from which i want to read the data.

Get Excel Values1.vi is the one i am using to get data dat from .xls files.

How can I use it to get data from .xlsm files ?

I want to read data directly from this .xlsm file without changing it to any other format.

Please help!

[GerdW]

Hi sharmasargam,

I get error 97 after the "Find" operation inside GetXL_CellValues_2D_String.vi - regardless of the Excel file format (xlsm or xls)! Did this VI ever work for you?

Why do you search for an empty string inside a range?

[sharmasargam9@gmail.com]

Yes, It works for me for .xls.

I am sending you the snapshops of what i am adding as a range and string and what data I am getting from .xls.

This is exactly what i want from .xlsm.

But i get the same error code 97 with  .xlsm.

[GerdW · Accepted solution]

Hi sharmasargam,

when I use your VI with the settings from your screenshots I still get error97 regardless of the filetype (xlsm or xls). Did this VI ever work for you - with the settings you gave us? (Btw. I'm using Office2010.)

Btw. all your Close functions don't work as expected: they should close worksheet/workbook/application regardless of the error state at their input (as any other Close operation in LabVIEW)! It's a shame I have to kill Excel using the task manager after running your VIs…