Hide The Rows or Columns of Excel Spreadsheet Using LabVIEW

Updated Nov 23, 2020

Issue Details

How can I hide rows or columns of an Excel spreadsheet programmatically using the LabVIEW?

Solution

You can use Excel's ActiveX to use Excel's native functions in LabVIEW. One of the ways to get the Excel ActiveX of Worksheet reference is using Excel Get ActiveX References.vi of LabVIEW Report Generation Toolkit. For more details, please refer to the attached example file. 
 

Additional Information

For more details about the Excel ActiveX property, please refer to the following link. External Link : Worksheet.Range property (Excel)