Hi there, I tried to use a for loop from 0 to sheet.cells.columns.count to check if the column width is 0.0 in order to find any hidden columns. However, the columns.count is always 1, and the rows.count is always 18.
for (int i = 0; i < columnCount; i++){
double width = sheet.Cells.GetColumnWidth(i);
if (width == 0.0) {//MarkColumnAsHidden();}
}
When I open Excel I see columns A thru V (22 columns) and rows are usually 50 or 100, but if I want to make sure that I am checking all of my available cols and rows, how can I enumerate with either a GetNext() or use a maximum constant using (For i to MaxColumns) types of Properties.
Thanks,
Karen Schmidt