Delete Columns


We have a Excel Template with several columns. We want to delete now differently columns. Is there a possibility by API Columns to delete?

Thanks for you timely help in this matter.


Dear Hans,

Currently this feature is not supported.

You can try an alternative solution: set the column width to 0. So this column is hidden. And you can put null value to cell which you want to delete.


Dear Laurence,

thank you for the fast answer. With set the column width to 0 works it well.
How can I set the cell value to Null?



Dear Hans,

You can try the following sample code:

Cells cells = excel.Worksheets[0].Cells;

So in Cell “B2”, the data you set in designer file is cleared.