Insert columns

Oct 13, 2011 at 11:32 AM
Edited Oct 13, 2011 at 11:32 AM


How can I insert cells\columns before or after the specified address?

I need to insert a certain number of columns before and after specific addresses, so that the column on the right have not changed their value, and shifted to the right.
Copying too slowly in this case, the files are very large.
Help, please.


Oct 19, 2011 at 6:26 AM

No, there is no method to insert column yet.

Oct 26, 2011 at 5:15 AM

Is there any plan to add ExcelWorksheet.InsertColumn?

If so, when?

Oct 28, 2011 at 3:26 PM

For performance reasons this has not been implemented. To get this to work I will have to rewrite the internal cell store, so it's quite a lot of work. When I have the time to fix it I will, but I cant give you a date.

But feel free to implement it if you need it :)

Dec 11, 2012 at 3:11 PM


first of all many thanks for your lib? it helps me a lot. Just wondering is there updates regarding inserting columns functionality? Or can you advice how it can be done better way using your lib? Ive tried combine using epplus with interop, but last one is ugly and inconvenient, so i left that idea. 

Thanks in advance

Dec 11, 2012 at 7:10 PM


Inserting columns is on the long term roadmap. Jan is working on it, but it will not be ready until the next major version since it will include a total rewrite of the Cell storage.

May 23, 2013 at 8:15 AM
Will it be included in the next release? and when?
Mar 23, 2015 at 7:53 AM

Is the Insert functionality enabled yet ?