This project has moved and is read-only. For the latest updates, please go here.

Insert Column into Existing Spreadsheet

Aug 18, 2010 at 6:06 PM

Is there a method (or other solution) to insert a new column into an existing spreadsheet? I see the methods to delete a row and insert a row but nothing for a column.

Aug 19, 2010 at 7:43 AM

No, but i guess I should add that. There is no good solution for it right now.

You have to move the cells yourself, copying values, formulas, styles...

I have added a copy method to the ExcelRange class that could be used (In changeset 62343), but it's not in the released version and it's not fully tested.


Aug 23, 2010 at 12:30 AM

Thanks Jan.... I'll wait a while for that to be added. I appreciate the quick resonse.