public void testClone() throws Exception { XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("WithDrawing.xlsx"); XSSFSheet sheet1 = wb.getSheetAt(0); XSSFSheet sheet2 = wb.cloneSheet(0); // the source sheet has one relationship and it is XSSFDrawing List<POIXMLDocumentPart> rels1 = sheet1.getRelations(); assertEquals(1, rels1.size()); assertTrue(rels1.get(0) instanceof XSSFDrawing); List<POIXMLDocumentPart> rels2 = sheet2.getRelations(); assertEquals(1, rels2.size()); assertTrue(rels2.get(0) instanceof XSSFDrawing); XSSFDrawing drawing1 = (XSSFDrawing) rels1.get(0); XSSFDrawing drawing2 = (XSSFDrawing) rels2.get(0); assertNotSame(drawing1, drawing2); // drawing2 is a clone of drawing1 List<XSSFShape> shapes1 = drawing1.getShapes(); List<XSSFShape> shapes2 = drawing2.getShapes(); assertEquals(shapes1.size(), shapes2.size()); for (int i = 0; i < shapes1.size(); i++) { XSSFShape sh1 = shapes1.get(i); XSSFShape sh2 = shapes2.get(i); assertTrue(sh1.getClass() == sh2.getClass()); assertEquals(sh1.getShapeProperties().toString(), sh2.getShapeProperties().toString()); } assertNotNull(XSSFTestDataSamples.writeOutAndReadBack(wb)); }