Insert Column into Existing Spreadsheet

Aug 18, 2010 at 5: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.

Coordinator
Aug 19, 2010 at 6: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.

Jan

Aug 22, 2010 at 11:30 PM

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

Jon