We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

UnHide all columns

Is there anyway i can unhide all the columns at once?

Hi,


I think you may use Cells.UnhideColumns() method to make your desired number of columns visible in a single step.
e.g
//… Make the first 100 columns visible with 8.43 wide as standard width
worksheet.Cells.UnhideColumns(0, 100, 8.43);

UnhideColumns (Method).
Parameters for the method:
int column index,
int totalColumns,
double Column width.

Remarks:
It only applies to the columns width that are hidden columns.

See the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Hiding+Unhiding+Rows+and+Columns