Unhide all Columns and rows in the excel file

Aspose.Cells Product Family
1

Is there a way to unhide all the columns and rows in the excel files? Thanks for you help in advance

2

Hi,

Thank you for Considering Aspose.

You can use Cells.UnhideRow and Cells.UnhideColumn methods to unhide the rows and columns. Please see the following link for more details on Hiding / Unhinding of rows and columns

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/hidingunhiding-rows-and-columns.html

For Unhiding multiple rows or columns, you can loop through the indexes and unhide the rows and columns one by one. Please see the Sample code for your help

Sample Code:-

Workbook workbook = new Workbook();
workbook.Open("c:\\Book2.xls");
Worksheet sheet = workbook.Worksheets[0];

//CreateStaticData(workbook);

//Unhide the first 100 rows and setting there height to 15
for (int i = 0; i < 100; i++)
{
sheet.Cells.UnhideRow(i, 15);
}
//Unhide the first 100 columns and setting there width to 15
for(int i=0;i<100;i++)
{
sheet.Cells.UnhideColumn(i, 15);
}
workbook.Save("DisplayRowsColumns.xls",FileFormatType.Default,SaveType.OpenInExcel,this.Response);

Thank you & Best Regards,