Easily remove empty columns

[Paul Meems]

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?

[Abirami Varadharajan]

Hi Paul, 

Greetings from Syncfusion. 

We have prepared a sample to remove the empty columns from the worksheet and the sample can be downloaded from the following link. 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SkipBlank1085659490.zip  

Kindly check and let us know if this is helpful. 

Regards, 

Abirami 

[Paul Meems]

Thanks for the sample. It works great.

This issue can be closed.

[Abirami Varadharajan]

Hi Paul, 

Thank you for updating us. 

We are glad that your requirement is fulfilled with the shared sample. Please let us know if you need further assistance. 

 

Regards, 

Abirami