Hide/Unhide Rows and Columns

Aspose.Cells Product Family
1

Hi ,

Please provide me some links for hide/unhide Rows and Columns in Aspose web Grid.

Thanks,
Mahesh


2

Hi Aspose Team,

I want to hide certain columns which are binding dynamically from the Database to Aspose.Cells.GridWeb Control.

I am unable to find any properties to hide the columns in the GridWeb.

So, I have set width of the column to zero(using shown below code). But, My client is not fine of making the columns width to zero as it is creating thick border between other columns. Please check the attached pic.

sheet.Cells.SetColumnWidth(i, new Unit(0, UnitType.Point));


Please let me know if there is any other way to hide the columns.

3

Hi,


I think you are doing fine as set the row height will hide the row for display.
"But, My client is not fine of making the columns width to zero as it is creating thick border between other columns. Please check the attached pic"
Well, if you could check the feature of hiding cols/rows in Ms Excel (manually) also does the hide operation in the same way and the thick border is inevitable.

Thanks,