LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Hiding Rows in an Excel Worksheet programmatically through automation.

Need to hide all the rows till the end that dont have any data in an excel worksheet. Please sugest how should I do it .
0 Kudos
Message 1 of 2
(2,648 Views)
Hello,

Do you mean that you just want to display the data that exists in the database? You might want to make use of the "Used Range" property. Take a look at the attached VI I wrote. It appends data to the end of an existing Excel spreadsheet, but you could easily modify it to use the "Value" property rather than the "Count" to retrieve the values and display them.

I hope this helps! Let me know if you'd like any additional help coding (I know ActiveX can get messy quickly).

Liz Fausak
National Instruments
Download All
0 Kudos
Message 2 of 2
(2,648 Views)