Does ASPOSE.Excel allow you to “insert” a column? If so how? I’d like to take my template then insert several cells keeping the data consistent for the cells to the right and left of the column I insert from.
Thanks for your consideration.
Do you mean the “Insert Column” feature in Excel?
For example, in your template you put data in cell A1 and B1. You insert a column between A and B column. Then a new column is inserted the data B1 is moved to C1. Now you can insert data in B1 without overriding the previous data.
If so, I have to say that this feature currently is not supported.
I will investigate this feature.
Has there been any progress on this?
I would also like to be able to insert rows, as well as columns. The use for this is that I want to be able to create a template with existing formatted information. and then insert a bunch of rows ABOVE that info, so that it gets pushed down, then I can go back into the new rows I have created and populate them with data.
Did your template contain chart, comments or formula? If yes, it’s difficult to implement the “Insert” feature as you need.
Otherwise, if your template only contains cell value, style or picture, I can provide these feature within one month and a half.
Is there any progress on this ? I have the same problem.
Please check Cells.InsertRow and Cells.InsertColumn method.