Copy Shapes between Worksheets

Sometimes, you need to copy elements on a worksheet, for example, pictures, charts and other drawing objects, between worksheets. Aspose.Cells for Python via .NET supports this feature. Charts, images, and other objects can be copied with the highest degree of precision.

This article gives you a detailed understanding of how to copy shapes between worksheets.

Copying a Picture from one Worksheet to Another

To copy a picture from one worksheet to another, use the Worksheet.pictures.add method as shown in the sample code below.

Copy a Chart from one Worksheet to Another

The following code demonstrates the use of Worksheet.shapes.add_copy method to copy a chart from one worksheet to another.

Copy Controls and Other Drawing Objects from One Worksheet to Another

To copy controls and other drawing objects, use the Worksheet.shapes.add_copy method as shown in the example below.