Set Hide Option for Excel Row, Column and Sheet using Dyn‑Hide Form

Contents
[ ]

Aspose.Cells for Reporting Services hides any specified row, column, or sheet based on the Hide parameters that are set. The parameters include:

  • SheetName – represents a worksheet that specifies a hide object.
  • Type – represents the hide object type. It includes worksheets, rows, and columns.
  • Row/Column Index – represents the index of the specified hide object. When the type is worksheet, the value is null. Column index supports characters. The index value starts from 1.
  • Hide State – represents the hide state value. The value can be true, false, or an Excel formula. This parameter only supports Reporting Services report parameters.

Specifying hide options

todo:image_alt_text

Set a Table's Hide Attributes from the Modify Attribute Form