Hello,
I would like to put SimpleShape on ChartSheet.
I tried source as shown below, but it made an empty chart sheet.
Is it unsupported yet?
Utils.openWorkbook is to open a file, and Utils.saveWorkbook is to
save a workbook.
ChartSheet.xlsx have only one empty chart sheet.
---------------------------------------------------------------
Workbook workbook = Utils.openWorkbook("ChartSheet.xlsx");
XSSFChartSheet sheet = (XSSFChartSheet)workbook.getSheetAt(0);
XSSFDrawing drawing = (XSSFDrawing) sheet.createDrawingPatriarch();
XSSFClientAnchor anchor = drawing.createAnchor(0, 0,
XSSFShape.EMU_PER_PIXEL*100, XSSFShape.EMU_PER_PIXEL*100, 0, 0, 0, 0);
XSSFSimpleShape shape = drawing.createSimpleShape(anchor);
shape.setFillColor(0x00, 0xff, 0xff);
Utils.saveWorkbook(workbook, "new.xlsx");
---------------------------------------------------------------
--
OGAI Yuta
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
