Hi Alain,
I'll paste some test code here. In my work we have a lot of restrictions when
it comes to websites.
Sorry I don't know how to format this code.
Important: the chartModel.xlsx should contain a chart, preferably with no
relations. After all you need the model to be copied to your report but then
you must at least implement the data source for the chart, maybe also the
title, the series names, etc. But the heavy customization of the chart is
already done in the model.
//Open chart model file
//My use experience: one chart par xlsx model file, in one sheet. Could
be otherwise of course.
FileInputStream in = new FileInputStream("c:/temp/chartModel.xlsx");
XSSFWorkbook srcWB = new XSSFWorkbook(in);
XSSFWorkbook destWB = new XSSFWorkbook();
XSSFSheet destSH = destWB.createSheet();
XSSFDrawing destDR = destSH.createDrawingPatriarch();
int sheetNum = 0;
XSSFSheet srcSH = srcWB.getSheetAt(sheetNum);
List<POIXMLDocumentPart> srcRels =
srcSH.createDrawingPatriarch().getRelations();
for (POIXMLDocumentPart srcRel : srcRels)
{
if (srcRel instanceof XSSFChart)
{
XSSFChart srcChart = (XSSFChart) srcRel;
//Create chartSpace and chart by parsing source chart
CTChartSpace chartSpace =
ChartSpaceDocument.Factory.parse(srcChart.getPackagePart().getInputStream(),
POIXMLTypeLoader.DEFAULT_XML_OPTIONS).getChartSpace();
CTChart ctc = chartSpace.getChart();
//XSSFClientAnchor origAnch = chart.getGraphicFrame().getAnchor();
//Frame is null ! I tried to get anchor using the following:
CTMarker from = ((XSSFDrawing)
srcChart.getParent()).getCTDrawing().getTwoCellAnchorArray(0).getFrom();
CTMarker to = ((XSSFDrawing)
srcChart.getParent()).getCTDrawing().getTwoCellAnchorArray(0).getTo();
XSSFClientAnchor anchor = new XSSFClientAnchor((int) from.getColOff(),
(int) from.getRowOff(), (int) to.getColOff(), (int) to.getRowOff(),
from.getCol(), from.getRow(), to.getCol(), to.getRow());
anchor.setAnchorType(AnchorType.MOVE_AND_RESIZE);
//Create chart in the destination workbook
XSSFChart destChart = destDR.createChart(anchor);
//A new XSSFChart constructor is needed maybe. The following 2
lines use reflection in order to force values for these 2 private variables of
XSSFChart
Utilities.setVariable(destChart, "chartSpace", chartSpace, true);
Utilities.setVariable(destChart, "chart", ctc, true);
}
}
//Write the new workbook (could also be one you already have opened for
edition)
FileOutputStream out = new FileOutputStream("c:/temp/test.xlsx");
destWB.write(out);
out.flush();
out.close();
in.close();
srcWB.close();
destWB.close();
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
