How to resize POI XSSFChart

Question

So i get chart from excel file (.xlsx) by this code.

XSSFSheet sheet = workbook.getSheetAt(10);
XSSFDrawing drawing = sheet.createDrawingPatriarch();
XSSFChart chart = drawing.getCharts().get(0);

and i need to resize this chart like

chart.setHeight(100);

Please refer answer below, and mark as Answered if it answers your query. — Srikanth Balaji, Feb 28 '17 at 08:53

score 0 · Accepted Answer · edited May 23 '17 at 12:25

Using CTMarker and XSSFDrawing, you shall resize with the coordinates as below.

XSSFDrawing draw= ((XSSFSheet)currentSheet).createDrawingPatriarch();
CTMarker chartEndCoords = CTMarker.Factory.newInstance();
chartEndCoords.setCol(column);
chartEndCoords.setColOff(0);
chartEndCoords.setRow(row);
chartEndCoords.setRowOff(0);
draw.getCTDrawing().getTwoCellAnchorArray(0).setTo(chartEndCoords);

Please refer here for detailed explanation- Resize in POI

How to resize POI XSSFChart

1 Answers1