I have several Excel sheets which when opened show a warning about too many columns.
When I use
worksheet.UsedRangeIncludesFormatting = false;
var lastColumn = worksheet.UsedRange.LastColumn;
I can see that for some worksheets the LastColumn is set to 1026, but they contain only between 45-50 columns.
Does XlsIO have an easy option to reset/remove the empty columns?
Or should I loop through all columns and remove the empty once one by one?