Skip to content

Copy Drawings

EPPlus supports copying of drawings. You can use the copy function in Drawings to make a copy of the drawing to a new destination. The destination can be the same worksheet, another worksheet or even a worksheet in a different workbook.

//Copy the first drawing in worksheet to a destination worksheet on row 5 column 1
worksheet.Drawings[0].Copy(destinationWorksheet, 5, 1);

'Copy the first drawing in worksheet to a destination worksheet on row 5 column 1
worksheet.Drawings(0).Copy(destinationWorksheet, 5, 1)

You can supply offsets for row and column as optional parameters

//Copy the first drawing in worksheet to a destination worksheet on row 5 column 1,
//with an offset for both the row and the column.
//The two last parameters are the row offset and the column offset.
worksheet.Drawings[0].Copy(destinationWorksheet, 5, 1, 15000, 15000);

'Copy the first drawing in worksheet to a destination worksheet on row 5 column 1,
'with an offset for both the row and the column.
'The two last parameters are the row offset and the column offset.
worksheet.Drawings(0).Copy(destinationWorksheet, 5, 1, 15000, 15000)