Copy worksheet including charts from one workbook to another

Aspose.Cells Product Family
1


Hello -

We are currently trying to copy a worksheet using Aspose.Excel from one worksheet to another. The copy routine only copies data and formatting, but not any charts or pictures. Is there anyway to do this?

2

Worksheet.Copy method doesn’t copy drawing objects. Please try Worksheets.AddCopy method.

3

Thanks for the quick reply. I saw the addcopy function, but it seems like it would only work for copying a worksheet within the same workbook. How would I copy a worksheet into another workbook?

4

Copying drawing object in different workbooks are not supported yet. It’s too complex to do it now.

5

Do you have any plans to add this functionality to a future release? If so, do you have any estimates on timing?

6

I will investigate this feature and add it to Aspose.Excel in the future release. I think it will take about 2 months.

7

Laurence -

Have you had time to evaluate adding the functionality to copy a chart from a worksheet in 1 workbook to a worksheet in another workbook? Is this slated for development any time soon? The reason I ask is my company is really pushing me to add functionality to an application I support that uses your component. I would hate to have to maintain 2 seperate components for working with Excel or worse yet rearchitecting things to use a new component altogether.

Thanks,

Brian

8

Hi Brian,

Please try Aspose.Cells for .NET (Latest Version) . It’s supported.

9

This is perfect! You guys are awesome!