Read non-hidden cells from Excel file.

[Aneesh]

Hi All Good After noon.,

I have a requirement to read an Excel file elements.

In the Excel file, some parts are made hidden using 'Subtotal' property.

The hidden parts are not continuos.

I have to read the only the non-hidden part.

How shall I know the hidden cell, so that I can ignore them from Read?

Looking forward to your help.!!!

Thanks in Advance

Aneesh PS

NB: I am using LabVIEW 6.1 Basic Version (no Report Generation tool kit installed )

[Elsa Fung]

not sure what the subtotal property is...

if you post your Excel file, it might help ^_^

[Aneesh]

I don't know more about 'Subtotal'.

But I have such a file. I am attaching such one.

Here "IBM Data" is hidden with Subtotal.

As of my knowledge subtotal is created by Data->Subtotal from Excel Tool.

I think this information is enough.

Thanks and Regards

Aneesh PS

[Elsa Fung]

do you have ActiveX?

try this VI and see if it works (i downloaded this from the LabVIEW example engine)

depending on the Excel version you have on your computer, you might need to edit the VI a little, so i attached 2 VIs, one for Excel 2000 and one for Excel 2003, hope this helps

* i have LV 8, so i'm not sure if you can open the VIs, the first attachment is the original VI i downloaded from LabVIEW example engine, if the other 2 don't open, this one should *

Message Edited by Elsa Fung on 01-18-2006 07:07 AM

[Aneesh]

Yes I am using ActiveX controls for getting the Excel Properties.

As in your code, we have reached till the 'Range' of the Sheet.

After that we cannot find any property related to 'Subtotal'.

I think you can help me.

Thanks in Advance

Aneesh PS

[Elsa Fung]

do you know which cells the 'subtotal' is (and are they always in the same cells)?

You will have to know which cell you want to read from it

which cell(s) are you trying to read exactly (from the spreadsheet you uploaded), maybe that'll help me understand what you're trying to do ^_^

** and what version of LV and Excel do you have **

Message Edited by Elsa Fung on 01-20-2006 06:22 AM

[Aneesh]

I want to find out which cells have the property 'Subtotal'.

In the file which I have uploaded earlier, I want to read the cells other than cells inside the '+' sign in the left side.

Thanks and Regards

Aneesh PS

[Elsa Fung]

does this VI help?

when you run this VI, it'll prompt for an Excel spreadsheet

then it'll go thru cells C1 to C99 and add the cell to the array (in the front panel) if the cell contains the words "SUBTOTAL(" in its formula

you can edit it a little to make it search different cell ranges, let me know if this is the right direction ^_^

** sorry to reply so late, got caught on something else my boss want me to do ^_^