hiding rows in excel!

[srini]

Hi,
I need to hide the unused rows/columns when the file is open by the user from LabVIEW. I used the UsedRange.Rows/Columns.count to get the number of columns and rows that are used in my excel file. After this, it is not clear as to where to use these values so as to hide the rows/columns. Can anyone help me?

Thanx & Regards,
Srini.

[Michael_Munroe]

If the UsedRange is the top left corner of the worksheet, then you can use these counts to identify the rows and columns to hide. Add one to the Rows.Count and Columns.Count value to get the starting row and column numbers.

Use the Range Invoke Node to select the cells from Axx to A65535. Feed this range into the EntireRow Property Node and then into the Hidden Property Node. Write a True to this property.

Substitute EntireColumn to hide the columns from x1 to IV1.

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz

[srini]

Hi,
I tried with the Range Invoke Node property. But I am still not getting how to select cells from Axxx from A65535 or X1 to 1V1. I have attached my vi . Please help me on what to do. Thanx in advance.

[Michael_Munroe]

The key is to cascade the output of one node into the reference of the next. The specified Range is not selected, but passed to the next node as a specific range. Also the Range has to use the Worksheet as the ref and not the UsedRange as in your code.

See the modified VI which hard-codes the addresses that you require.

Michael Munroe

[srini]

Hi Michael,
Thanx a lot. It works very fine as per my requirement.