I have a report that starts with an existing Excel file and modifys that file to fill in data. During the course of producing the report, I need to copy the contents of one worksheet to a new worksheet. I've figured out how to add the new worksheet, but not how to copy the "base" one to the newly created sheet. I will copy this default sheet multiple times to newly created sheets.
Additionally, on another sheet, I need to insert a new column and copy the contents of the different column.
I'm using 7.2.20072.61. Any code examples (vb.net 2005) are appreciated.
Thanks!
Hi, I would like to auto update a chart after inserting a new column in my worksheet. How can I do this ?
The abilities to copy worksheets or insert, delete, or copy rows and columns is not supported. You can submit feature requests for these here: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
The only way to accomplish any of these tasks would be to manually copy data and formatting of indiviual cells to the new worksheet or column or to manually shift over all data and formatting.