Add Hide Function in Aspose.Cells for Reporting Services Client

Overview

The Hide function lets you conceal specified rows, columns, or entire worksheets in an Excel report generated by Aspose.Cells for Reporting Services.

There are two ways to set hide attributes:

1. Set hide attributes for a worksheet, rows, or columns – Use the Modify Attribute form to define hide options for individual cells, rows, columns, or the whole sheet.
   
   Set hide attributes for worksheet, rows and columns

2. Set a table’s hide attributes using the Modify Attribute dialog – Apply hide settings to an entire table at once.
   
   Set hide option for Excel row, column and sheet using dyn‑hide form