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: