Attachment #27021 for bug #51196

View | Details | Raw Unified | Return to bug 51196
Collapse All | Expand All




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel.examples;

import java.io.FileOutputStream;
import java.util.Date;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 

/**
 * Illustrates how to create cell and set values of different types.
 */
public class ScatterChart {


	public static void main(String[]args) throws Exception {
        XSSFWorkbook wb = new XSSFWorkbook();
        CreationHelper creationHelper = wb.getCreationHelper();
        XSSFSheet sheet = wb.createSheet("new sheet");
		final int NUM_OF_ROWS = 3;
		final int NUM_OF_COLUMNS = 10;

        // Create a row and put some cells in it. Rows are 0 based.
        Row row;
		Cell cell;
		for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) {
			row = sheet.createRow((short)rowIndex);
			for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) {
				cell = row.createCell((short)colIndex);
				cell.setCellValue(colIndex * (rowIndex + 1));
			}
		}

		row = sheet.createRow((short)1);
		for (int i = 0; i < 10; i++) {
			cell = row.createCell((short)i);
			cell.setCellValue(i * 2);
		}

		row = sheet.createRow((short)2);
		for (int i = 0; i < 10; i++) {
			cell = row.createCell((short)i);
			cell.setCellValue(i * 3);
		}

		XSSFClientAnchor anchor = new XSSFClientAnchor(0,0,0,0,0,NUM_OF_COLUMNS + 1,NUM_OF_COLUMNS,NUM_OF_ROWS + 10);

        XSSFDrawing drawing = sheet.createDrawingPatriarch();

        XSSFChart chart = drawing.createChart(anchor);
        XSSFChartLegend legend = chart.getOrCreateLegend();
        legend.setPosition(XSSFChartLegend.Position.RIGHT);

        ScatterChartData data = chart.getChartDataFactory().getScatterChartData();

        ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
        ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);

        ScatterChartSerie firstSerie = data.addSerie();
        firstSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
        firstSerie.setXValues(sheet, new CellRangeAddress(1, 1, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));

        ScatterChartSerie secondSerie = data.addSerie();
        secondSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
        secondSerie.setYValues(sheet, new CellRangeAddress(2, 2, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));

        chart.plot(data, bottomAxis, leftAxis);

		// Write the output to a file
        FileOutputStream fileOut = new FileOutputStream("ooxml-scatter-chart.xlsx");
        wb.write(fileOut);
        fileOut.close();
	}
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel;

import java.util.List;

import org.apache.poi.ss.usermodel.charts.ChartData;
import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;

/**
 * High level representation of a chart.
 *
 * @author Roman Kashitsyn
 */
public interface Chart {
	
	/**
	 * @return an appropriate ChartDataFactory implementation
	 */
	ChartDataFactory getChartDataFactory();

	/**
	 * @return an appropriate ChartAxisFactory implementation
	 */
	ChartAxisFactory getChartAxisFactory();

	/**
	 * @return list of all chart axis
	 */
	List<? extends ChartAxis> getAxis();

	/**
	 * Plots specified data on the chart.
	 *
	 * @param data a data to plot
	 */
	void plot(ChartData data, ChartAxis... axis);
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 *  Specifies the possible crossing states of an axis.
 *
 * @author Roman Kashitsyn
 */
public enum AxisCrossBetween {
	/**
	 * Specifies the value axis shall cross the category axis
	 * between data markers.
	 */
	BETWEEN,
	/**
	 * Specifies the value axis shall cross the category axis at
	 * the midpoint of a category.
	 */
	MIDPOINT_CATEGORY
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * Specifies the possible crossing points for an axis.
 *
 * @author Roman Kashitsyn
 */
public enum AxisCrosses {
	/**
	 * The category axis crosses at the zero point of the value axis (if
	 * possible), or the minimum value (if the minimum is greater than zero) or
	 * the maximum (if the maximum is less than zero).
	 */
	AUTO_ZERO,
	/**
	 * The axis crosses at the maximum value.
	 */
	MIN,
	/**
	 * Axis crosses at the minimum value of the chart.
	 */
	MAX
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * Specifies the possible ways to place a picture on a data point, series, wall, or floor.
 *
 * @author Roman Kashitsyn
 */
public enum AxisOrientation {
	/**
	 * Specifies that the values on the axis shall be reversed
	 * so they go from maximum to minimum.
	 */
	MAX_MIN,
	/**
	 * Specifies that the axis values shall be in the usual
	 * order, minimum to maximum.
	 */
	MIN_MAX
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * Enumeration of all possible axis positions.
 *
 * @author Roman Kashitsyn
 */
public enum AxisPosition {
	BOTTOM,
	LEFT,
	RIGHT,
	TOP
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * High level representation of chart axis.
 *
 * @author Roman Kashitsyn
 */
public interface ChartAxis {
	
	/**
	 * @return axis id
	 */
	long getId();

	/**
	 * @return axis position
	 */
	AxisPosition getPosition();

	/**
	 * @param new axis position
	 */
	void setPosition(AxisPosition position);

	/**
	 * @return axis number format
	 */
	String getNumberFormat();

	/**
	 * @param format axis number format
	 */
	void setNumberFormat(String format);

	/**
	 * @param logBase a number between 2 and 1000 (inclusive)
	 */
	void setLogBase(Double logBase);

	/**
	 * @return axis log base or null if not set
	 */
	Double getLogBase();

	/**
	 * @return axis minimum or null if not set
	 */
	Double getMinimum();

	/**
	 * @param min axis minimum
	 */
	void setMinimum(Double min);

	/**
	 * @return axis maximum or null if not set
	 */
	Double getMaximum();

	/**
	 * @param max axis maximum
	 */
	void setMaximum(Double max);

	/**
	 * @return axis orientation
	 */
	AxisOrientation getOrientation();

	/**
	 * @param axis orientation
	 */
	void setOrientation(AxisOrientation orientation);

	/**
	 * @param crosses axis cross type
	 */
	void setCrosses(AxisCrosses crosses);

	/**
	 * @return axis cross type
	 */
	AxisCrosses getCrosses();

	/**
	 * Declare this axis cross another axis.
	 * @param axis that this axis should cross
	 */
	void crossAxis(ChartAxis axis);
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

import org.apache.poi.ss.usermodel.Chart;

/**
 * A factory for different chart axis.
 *
 * @author Roman Kashitsyn
 */
public interface ChartAxisFactory {
	
	/**
	 * @return new value axis
	 */
	ValueAxis createValueAxis(AxisPosition pos);

}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

import org.apache.poi.ss.usermodel.Chart;

/**
 * A base for all chart data types.
 *
 * @author Roman Kashitsyn
 */
public interface ChartData {

	/**
	 * Fills a chart with data specified by implementation.
	 *
	 * @param chart a chart to fill in
	 * @param axis chart axis to use
	 */
	void fillChart(Chart chart, ChartAxis... axis);
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * A factory for different chart data types.
 *
 * @author Roman Kashitsyn
 */
public interface ChartDataFactory {
	
	/**
	 * @return an appropriate ScatterChartData instance
	 */
	ScatterChartData getScatterChartData();

}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

import java.util.List;

/**
 * @author Roman Kashitsyn
 */
public interface ScatterChartData extends ChartData {
	/**
	 * @return a new scatter chart serie
	 */
	ScatterChartSerie addSerie();

	/**
	 * @return list of all series
	 */
	List<? extends ScatterChartSerie> getSeries();
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;

/**
 * @author Roman Kashitsyn
 */
public interface ScatterChartSerie {

	/**
	 * @param sheet a sheet to take range from
	 * @param address a column or a row with values
	 */
	void setXValues(Sheet sheet, CellRangeAddress address);
	
	/**'
	 * @param sheet a sheet to take range from
	 * @param address a column or a row with values
	 */
	void setYValues(Sheet sheet, CellRangeAddress address);

}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.ss.usermodel.charts;

/**
 * @author Roman Kashitsyn
 */
public interface ValueAxis extends ChartAxis {

	/**
	 * @return cross between type
	 */
	AxisCrossBetween getCrossBetween();

	/**
	 * @param crossBetween cross between type
	 */
	void setCrossBetween(AxisCrossBetween crossBetween);
}

Lines 80-89 public class CellRangeAddress extends CellRangeAddressBase { Link Here

(-)a/src/java/org/apache/poi/ss/util/CellRangeAddress.java (-2 / +16 lines)
80	* like single cell references (e.g. 'A1' instead of 'A1:A1').	80	* like single cell references (e.g. 'A1' instead of 'A1:A1').
81	*/	81	*/
82	public String formatAsString() {	82	public String formatAsString() {
		83	return formatAsString(null, false);
		84	}
		85
		86	/**
		87	* @return the text format of this range using specified sheet name.
		88	*/
		89	public String formatAsString(String sheetName, boolean useAbsoluteAddress) {
83	StringBuffer sb = new StringBuffer();	90	StringBuffer sb = new StringBuffer();
84	CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn());	91	if (sheetName != null) {
85	CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn());	92	sb.append(sheetName);
		93	sb.append("!");
		94	}
		95	CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(),
		96	useAbsoluteAddress, useAbsoluteAddress);
		97	CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(),
		98	useAbsoluteAddress, useAbsoluteAddress);
86	sb.append(cellRefFrom.formatAsString());	99	sb.append(cellRefFrom.formatAsString());
		100
87	//for a single-cell reference return A1 instead of A1:A1	101	//for a single-cell reference return A1 instead of A1:A1
88	if(!cellRefFrom.equals(cellRefTo)){	102	if(!cellRefFrom.equals(cellRefTo)){
89	sb.append(':');	103	sb.append(':');

Lines 21-26 import java.io.IOException; Link Here

(-)a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFChart.java (-23 / +69 lines)
21	import java.io.OutputStream;	21	import java.io.OutputStream;
22	import java.util.HashMap;	22	import java.util.HashMap;
23	import java.util.Map;	23	import java.util.Map;
		24	import java.util.List;
		25	import java.util.ArrayList;
24		26
25	import javax.xml.namespace.QName;	27	import javax.xml.namespace.QName;
26		28
Lines 28-33 import org.apache.poi.POIXMLDocumentPart; Link Here
28	import org.apache.poi.openxml4j.opc.PackagePart;	30	import org.apache.poi.openxml4j.opc.PackagePart;
29	import org.apache.poi.openxml4j.opc.PackageRelationship;	31	import org.apache.poi.openxml4j.opc.PackageRelationship;
30	import org.apache.poi.util.Internal;	32	import org.apache.poi.util.Internal;
		33	import org.apache.poi.ss.usermodel.Chart;
		34	import org.apache.poi.ss.usermodel.charts.ChartAxis;
		35	import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;
		36	import org.apache.poi.xssf.usermodel.charts.XSSFChartDataFactory;
		37	import org.apache.poi.xssf.usermodel.charts.XSSFChartAxis;
		38	import org.apache.poi.xssf.usermodel.charts.XSSFValueAxis;
		39	import org.apache.poi.ss.usermodel.charts.ChartData;
		40	import org.apache.poi.ss.usermodel.charts.AxisPosition;
31	import org.apache.xmlbeans.XmlException;	41	import org.apache.xmlbeans.XmlException;
32	import org.apache.xmlbeans.XmlObject;	42	import org.apache.xmlbeans.XmlObject;
33	import org.apache.xmlbeans.XmlOptions;	43	import org.apache.xmlbeans.XmlOptions;
Lines 51-57 import org.w3c.dom.Text; Link Here
51	* @author Nick Burch	61	* @author Nick Burch
52	* @author Roman Kashitsyn	62	* @author Roman Kashitsyn
53	*/	63	*/
54	public final class XSSFChart extends POIXMLDocumentPart {	64	public final class XSSFChart extends POIXMLDocumentPart implements Chart, ChartAxisFactory {
55		65
56	/**	66	/**
57	* Parent graphic frame.	67	* Parent graphic frame.
Lines 67-77 public final class XSSFChart extends POIXMLDocumentPart { Link Here
67	*/	77	*/
68	private CTChart chart;	78	private CTChart chart;
69		79
		80	List<XSSFChartAxis> axis;
		81
70	/**	82	/**
71	* Create a new SpreadsheetML chart	83	* Create a new SpreadsheetML chart
72	*/	84	*/
73	protected XSSFChart() {	85	protected XSSFChart() {
74	super();	86	super();
		87	axis = new ArrayList<XSSFChartAxis>();
75	createChart();	88	createChart();
76	}	89	}
77		90
Lines 143-170 public final class XSSFChart extends POIXMLDocumentPart { Link Here
143	}	156	}
144		157
145	@Override	158	@Override
146	protected void commit() throws IOException {	159	protected void commit() throws IOException {
147	XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);	160	XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);
148		161
149	/*	162	/*
150	Saved chart space must have the following namespaces set:	163	Saved chart space must have the following namespaces set:
151	<c:chartSpace	164	<c:chartSpace
152	xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart"	165	xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart"
153	xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"	166	xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"
154	xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">	167	xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
155	*/	168	*/
156	xmlOptions.setSaveSyntheticDocumentElement(new QName(CTChartSpace.type.getName().getNamespaceURI(), "chartSpace", "c"));	169	xmlOptions.setSaveSyntheticDocumentElement(new QName(CTChartSpace.type.getName().getNamespaceURI(), "chartSpace", "c"));
157	Map<String, String> map = new HashMap<String, String>();	170	Map<String, String> map = new HashMap<String, String>();
158	map.put(XSSFDrawing.NAMESPACE_A, "a");	171	map.put(XSSFDrawing.NAMESPACE_A, "a");
159	map.put(XSSFDrawing.NAMESPACE_C, "c");	172	map.put(XSSFDrawing.NAMESPACE_C, "c");
160	map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");	173	map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");
161	xmlOptions.setSaveSuggestedPrefixes(map);	174	xmlOptions.setSaveSuggestedPrefixes(map);
162		175
163	PackagePart part = getPackagePart();	176	PackagePart part = getPackagePart();
164	OutputStream out = part.getOutputStream();	177	OutputStream out = part.getOutputStream();
165	chartSpace.save(out, xmlOptions);	178	chartSpace.save(out, xmlOptions);
166	out.close();	179	out.close();
167	}	180	}
168		181
169	/**	182	/**
170	* Returns the parent graphic frame.	183	* Returns the parent graphic frame.
Lines 181-186 public final class XSSFChart extends POIXMLDocumentPart { Link Here
181	this.frame = frame;	194	this.frame = frame;
182	}	195	}
183		196
		197	@Override
		198	public XSSFChartDataFactory getChartDataFactory() {
		199	return XSSFChartDataFactory.getInstance();
		200	}
		201
		202	@Override
		203	public XSSFChart getChartAxisFactory() {
		204	return this;
		205	}
		206
		207	@Override
		208	public void plot(ChartData data, ChartAxis... axis) {
		209	data.fillChart(this, axis);
		210	}
		211
		212	@Override
		213	public XSSFValueAxis createValueAxis(AxisPosition pos) {
		214	long id = axis.size() + 1;
		215	XSSFValueAxis valueAxis = new XSSFValueAxis(this, id, pos);
		216	if (axis.size() == 1) {
		217	ChartAxis ax = axis.get(0);
		218	ax.crossAxis(valueAxis);
		219	valueAxis.crossAxis(ax);
		220	}
		221	axis.add(valueAxis);
		222	return valueAxis;
		223	}
		224
		225	@Override
		226	public List<? extends XSSFChartAxis> getAxis() {
		227	return axis;
		228	}
		229
184	/**	230	/**
185	* Sets the width ratio of the chart.	231	* Sets the width ratio of the chart.
186	* Chart width is ratio multiplied by parent frame width.	232	* Chart width is ratio multiplied by parent frame width.




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel.charts;

import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.AxisPosition;
import org.apache.poi.ss.usermodel.charts.AxisOrientation;
import org.apache.poi.ss.usermodel.charts.AxisCrosses;
import org.apache.poi.xssf.usermodel.XSSFChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTLogBase;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScaling;
import org.openxmlformats.schemas.drawingml.x2006.chart.STOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrosses;

/**
 * Base class for all axis types.
 *
 * @author Roman Kashitsyn
 */
public abstract class XSSFChartAxis implements ChartAxis {

	protected XSSFChart chart;

	private static final double MIN_LOG_BASE = 2.0;
	private static final double MAX_LOG_BASE = 1000.0;

	protected XSSFChartAxis(XSSFChart chart) {
		this.chart = chart;
	}

	@Override
	public AxisPosition getPosition() {
		return toAxisPosition(getCTAxPos());
	}

	@Override
	public void setPosition(AxisPosition position) {
		getCTAxPos().setVal(fromAxisPosition(position));
	}

	@Override
	public void setNumberFormat(String format) {
		getCTNumFmt().setFormatCode(format);
		getCTNumFmt().setSourceLinked(true);
	}

	@Override
	public String getNumberFormat() {
		return getCTNumFmt().getFormatCode();
	}

	@Override
	public void setLogBase(Double logBase) {
		if (logBase < MIN_LOG_BASE ||
			MAX_LOG_BASE > logBase) {
			throw new IllegalArgumentException("Axis log base must be between 2 and 1000 (inclusive), got: " + logBase);
		}
		CTScaling scaling = getCTScaling();
		if (scaling.isSetLogBase()) {
			scaling.getLogBase().setVal(logBase.doubleValue());
		} else {
			scaling.addNewLogBase().setVal(logBase.doubleValue());
		}
	}

	@Override
	public Double getLogBase() {
		CTLogBase logBase = getCTScaling().getLogBase();
		if (logBase != null) {
			return Double.valueOf(logBase.getVal());
		}
		return null;
	}

	@Override
	public void setMinimum(Double min) {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMin()) {
			scaling.getMin().setVal(min.doubleValue());
		} else {
			scaling.addNewMin().setVal(min.doubleValue());
		}
	}

	@Override
	public Double getMinimum() {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMin()) {
			return Double.valueOf(scaling.getMin().getVal());
		} else {
			return null;
		}
	}

	@Override
	public void setMaximum(Double max) {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMax()) {
			scaling.getMax().setVal(max.doubleValue());
		} else {
			scaling.addNewMax().setVal(max.doubleValue());
		}
	}

	@Override
	public Double getMaximum() {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMax()) {
			return Double.valueOf(scaling.getMax().getVal());
		} else {
			return null;
		}
	}

	@Override
	public AxisOrientation getOrientation() {
		return toAxisOrientation(getCTScaling().getOrientation());
	}

	@Override
	public void setOrientation(AxisOrientation orientation) {
		CTScaling scaling = getCTScaling();
		STOrientation.Enum stOrientation = fromAxisOrientation(orientation);
		if (scaling.isSetOrientation()) {
			scaling.getOrientation().setVal(stOrientation);
		} else {
			getCTScaling().addNewOrientation().setVal(stOrientation);
		}
	}

	@Override
	public AxisCrosses getCrosses() {
		return toAxisCrosses(getCTCrosses());
	}

	@Override
	public void setCrosses(AxisCrosses crosses) {
		getCTCrosses().setVal(fromAxisCrosses(crosses));
	}

	protected abstract CTAxPos getCTAxPos();
	protected abstract CTNumFmt getCTNumFmt();
	protected abstract CTScaling getCTScaling();
	protected abstract CTCrosses getCTCrosses();

	private static STOrientation.Enum fromAxisOrientation(AxisOrientation orientation) {
		switch (orientation) {
			case MIN_MAX: return STOrientation.MIN_MAX;
			case MAX_MIN: return STOrientation.MAX_MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisOrientation toAxisOrientation(CTOrientation ctOrientation) {
		switch (ctOrientation.getVal().intValue()) {
			case STOrientation.INT_MIN_MAX: return AxisOrientation.MIN_MAX;
			case STOrientation.INT_MAX_MIN: return AxisOrientation.MAX_MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static STCrosses.Enum fromAxisCrosses(AxisCrosses crosses) {
		switch (crosses) {
			case AUTO_ZERO: return STCrosses.AUTO_ZERO;
			case MIN: return STCrosses.MIN;
			case MAX: return STCrosses.MAX;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisCrosses toAxisCrosses(CTCrosses ctCrosses) {
		switch (ctCrosses.getVal().intValue()) {
			case STCrosses.INT_AUTO_ZERO: return AxisCrosses.AUTO_ZERO;
			case STCrosses.INT_MAX: return AxisCrosses.MAX;
			case STCrosses.INT_MIN: return AxisCrosses.MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static STAxPos.Enum fromAxisPosition(AxisPosition position) {
		switch (position) {
			case BOTTOM: return STAxPos.B;
			case LEFT: return STAxPos.L;
			case RIGHT: return STAxPos.R;
			case TOP: return STAxPos.T;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisPosition toAxisPosition(CTAxPos ctAxPos) {
		switch (ctAxPos.getVal().intValue()) {
			case STAxPos.INT_B: return AxisPosition.BOTTOM;
			case STAxPos.INT_L: return AxisPosition.LEFT;
			case STAxPos.INT_R: return AxisPosition.RIGHT;
			case STAxPos.INT_T: return AxisPosition.TOP;
			default: return AxisPosition.BOTTOM;
		}
	}
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel.charts;

import org.apache.poi.ss.usermodel.charts.*;

/**
 * @author Roman Kashitsyn
 */
public class XSSFChartDataFactory implements ChartDataFactory {

	private static XSSFChartDataFactory instance;

	private XSSFChartDataFactory() {
		super();
	}

	/**
	 * @return new scatter chart data instance
	 */
	public XSSFScatterChartData getScatterChartData() {
		return new XSSFScatterChartData();
	}

	/**
	 * @return factory instance
	 */
	public static XSSFChartDataFactory getInstance() {
		if (instance == null) {
			instance = new XSSFChartDataFactory();
		}
		return instance;
	}

}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel.charts;

import java.util.List;
import java.util.ArrayList;

import org.apache.poi.ss.usermodel.Chart;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.charts.ScatterChartData;
import org.apache.poi.ss.usermodel.charts.ScatterChartSerie;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
import org.apache.poi.ss.usermodel.charts.ChartAxis;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterStyle;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterSer;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxDataSource;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumRef;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumDataSource;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx;
import org.openxmlformats.schemas.drawingml.x2006.chart.STScatterStyle;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrossBetween;
import org.openxmlformats.schemas.drawingml.x2006.chart.STOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.STTickLblPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;

import org.apache.poi.xssf.usermodel.XSSFChart;

/**
 * Represents DrawingML scatter chart.
 *
 * @author Roman Kashitsyn
 */
public class XSSFScatterChartData implements ScatterChartData {

	/**
	 * List of all data series.
	 */
	private List<Serie> series;

	public XSSFScatterChartData() {
		series = new ArrayList<Serie>();
	}

	public static class Serie implements ScatterChartSerie {
		private int id;
		private int order;
		private boolean useCache;
		private Sheet xSheet;
		private Sheet ySheet;
		private CellRangeAddress xAddress;
		private CellRangeAddress yAddress;

		public Serie(int id, int order) {
			super();
			this.id = id;
			this.order = order;
			this.useCache = false;
		}

		@Override
		public void setXValues(Sheet sheet, CellRangeAddress address) {
			this.xSheet = sheet;
			this.xAddress = address;
		}

		@Override
		public void setYValues(Sheet sheet, CellRangeAddress address) {
			this.ySheet = sheet;
			this.yAddress = address;
		}

		/**
		 * @param useCache if true, cached results will be added on plot
		 */
		public void setUseCache(boolean useCache) {
			this.useCache = useCache;
		}

		protected void addToChart(CTScatterChart ctScatterChart) {
			CTScatterSer scatterSer = ctScatterChart.addNewSer();
			scatterSer.addNewIdx().setVal(this.id);
			scatterSer.addNewOrder().setVal(this.order);

			CTAxDataSource xVal = scatterSer.addNewXVal();
			CTNumRef numRef = xVal.addNewNumRef();
			numRef.setF(xAddress.formatAsString(xSheet.getSheetName(), true));

			CTNumDataSource yVal = scatterSer.addNewYVal();
			numRef = yVal.addNewNumRef();
			numRef.setF(yAddress.formatAsString(ySheet.getSheetName(), true));
		}
	}

	@Override
	public XSSFScatterChartData.Serie addSerie() {
		int numOfSeries = series.size();
		Serie newSerie = new Serie(numOfSeries, numOfSeries);
		series.add(newSerie);
		return newSerie;
	}

	@Override
	public void fillChart(Chart chart, ChartAxis... axis) {
		if (!(chart instanceof XSSFChart)) {
			throw new IllegalArgumentException("Chart must be instance of XSSFChart");
		}

		XSSFChart xssfChart = (XSSFChart) chart;
		CTPlotArea plotArea = xssfChart.getCTChart().getPlotArea();
		CTScatterChart scatterChart = plotArea.addNewScatterChart();
		addStyle(scatterChart);

		for (Serie s : series) {
			s.addToChart(scatterChart);
		}

		for (ChartAxis ax : axis) {
			scatterChart.addNewAxId().setVal(ax.getId());
		}
	}

	@Override
	public List<? extends Serie> getSeries() {
		return series;
	}

	private void addStyle(CTScatterChart ctScatterChart) {
		CTScatterStyle scatterStyle = ctScatterChart.addNewScatterStyle();
		scatterStyle.setVal(STScatterStyle.LINE_MARKER);
	}
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel.charts;

import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.ValueAxis;
import org.apache.poi.ss.usermodel.charts.AxisPosition;
import org.apache.poi.ss.usermodel.charts.AxisOrientation;
import org.apache.poi.ss.usermodel.charts.AxisCrossBetween;
import org.apache.poi.ss.usermodel.charts.AxisCrosses;

import org.apache.poi.xssf.usermodel.XSSFChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScaling;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrossBetween;
import org.openxmlformats.schemas.drawingml.x2006.chart.STTickLblPos;

/**
 * Value axis type.
 *
 * @author Roman Kashitsyn
 */
public class XSSFValueAxis extends XSSFChartAxis implements ValueAxis {

	private CTValAx ctValAx;

	public XSSFValueAxis(XSSFChart chart, long id, AxisPosition pos) {
		super(chart);
		createAxis(id, pos);
	}

	@Override
	public long getId() {
		return ctValAx.getAxId().getVal();
	}

	@Override
	public void setCrossBetween(AxisCrossBetween crossBetween) {
		ctValAx.getCrossBetween().setVal(fromCrossBetween(crossBetween));
	}

	@Override
	public AxisCrossBetween getCrossBetween() {
		return toCrossBetween(ctValAx.getCrossBetween().getVal());
	}

	@Override
	protected CTAxPos getCTAxPos() {
		return ctValAx.getAxPos();
	}

	@Override
	protected CTNumFmt getCTNumFmt() {
		if (ctValAx.isSetNumFmt()) {
			return ctValAx.getNumFmt();
		}
		return ctValAx.addNewNumFmt();
	}

	@Override
	protected CTScaling getCTScaling() {
		return ctValAx.getScaling();
	}

	@Override
	protected CTCrosses getCTCrosses() {
		return ctValAx.getCrosses();
	}

	@Override
	public void crossAxis(ChartAxis axis) {
		ctValAx.getCrossAx().setVal(axis.getId());
	}

	private void createAxis(long id, AxisPosition pos) {
		ctValAx = chart.getCTChart().getPlotArea().addNewValAx();
		ctValAx.addNewAxId().setVal(id);
		ctValAx.addNewAxPos();
		ctValAx.addNewScaling();
		ctValAx.addNewCrossBetween();
		ctValAx.addNewCrosses();
		ctValAx.addNewCrossAx();
		ctValAx.addNewTickLblPos().setVal(STTickLblPos.NEXT_TO);

		setPosition(pos);
		setOrientation(AxisOrientation.MIN_MAX);
		setCrossBetween(AxisCrossBetween.MIDPOINT_CATEGORY);
		setCrosses(AxisCrosses.AUTO_ZERO);
	}

	private static STCrossBetween.Enum fromCrossBetween(AxisCrossBetween crossBetween) {
		switch (crossBetween) {
			case BETWEEN: return STCrossBetween.BETWEEN;
			case MIDPOINT_CATEGORY: return STCrossBetween.MID_CAT;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisCrossBetween toCrossBetween(STCrossBetween.Enum ctCrossBetween) {
		switch (ctCrossBetween.intValue()) {
			case STCrossBetween.INT_BETWEEN: return AxisCrossBetween.BETWEEN;
			case STCrossBetween.INT_MID_CAT: return AxisCrossBetween.MIDPOINT_CATEGORY;
			default:
				throw new IllegalArgumentException();
		}
	}
}

Return to bug 51196

Line 0 Link Here

(-)a/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java (+93 lines)
		1	/* ====================================================================
		2	Licensed to the Apache Software Foundation (ASF) under one or more
		3	contributor license agreements. See the NOTICE file distributed with
		4	this work for additional information regarding copyright ownership.
		5	The ASF licenses this file to You under the Apache License, Version 2.0
		6	(the "License"); you may not use this file except in compliance with
		7	the License. You may obtain a copy of the License at
		8
		9	http://www.apache.org/licenses/LICENSE-2.0
		10
		11	Unless required by applicable law or agreed to in writing, software
		12	distributed under the License is distributed on an "AS IS" BASIS,
		13	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
		14	See the License for the specific language governing permissions and
		15	limitations under the License.
		16	==================================================================== */
		17
		18	package org.apache.poi.xssf.usermodel.examples;
		19
		20	import java.io.FileOutputStream;
		21	import java.util.Date;
		22
		23	import org.apache.poi.ss.usermodel.*;
		24	import org.apache.poi.ss.util.*;
		25	import org.apache.poi.xssf.usermodel.*;
		26	import org.apache.poi.ss.usermodel.charts.*;
		27	import org.apache.poi.xssf.usermodel.XSSFWorkbook;
		28
		29	/**
		30	* Illustrates how to create cell and set values of different types.
		31	*/
		32	public class ScatterChart {
		33
		34
		35	public static void main(String[]args) throws Exception {
		36	XSSFWorkbook wb = new XSSFWorkbook();
		37	CreationHelper creationHelper = wb.getCreationHelper();
		38	XSSFSheet sheet = wb.createSheet("new sheet");
		39	final int NUM_OF_ROWS = 3;
		40	final int NUM_OF_COLUMNS = 10;
		41
		42	// Create a row and put some cells in it. Rows are 0 based.
		43	Row row;
		44	Cell cell;
		45	for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) {
		46	row = sheet.createRow((short)rowIndex);
		47	for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) {
		48	cell = row.createCell((short)colIndex);
		49	cell.setCellValue(colIndex * (rowIndex + 1));
		50	}
		51	}
		52
		53	row = sheet.createRow((short)1);
		54	for (int i = 0; i < 10; i++) {
		55	cell = row.createCell((short)i);
		56	cell.setCellValue(i * 2);
		57	}
		58
		59	row = sheet.createRow((short)2);
		60	for (int i = 0; i < 10; i++) {
		61	cell = row.createCell((short)i);
		62	cell.setCellValue(i * 3);
		63	}
		64
65	XSSFClientAnchor anchor = new XSSFClientAnchor(0,0,0,0,0,NUM_OF_COLUMNS + 1,NUM_OF_COLUMNS,NUM_OF_ROWS + 10);
66
67	XSSFDrawing drawing = sheet.createDrawingPatriarch();
68
69	XSSFChart chart = drawing.createChart(anchor);
70	XSSFChartLegend legend = chart.getOrCreateLegend();
71	legend.setPosition(XSSFChartLegend.Position.RIGHT);
72
73	ScatterChartData data = chart.getChartDataFactory().getScatterChartData();
74
75	ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
76	ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);
77
78	ScatterChartSerie firstSerie = data.addSerie();
79	firstSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
80	firstSerie.setXValues(sheet, new CellRangeAddress(1, 1, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
81
82	ScatterChartSerie secondSerie = data.addSerie();
83	secondSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
84	secondSerie.setYValues(sheet, new CellRangeAddress(2, 2, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
85
86	chart.plot(data, bottomAxis, leftAxis);
87
88	// Write the output to a file
89	FileOutputStream fileOut = new FileOutputStream("ooxml-scatter-chart.xlsx");
90	wb.write(fileOut);
91	fileOut.close();
92	}
93	}

Line 0 Link Here

(-)a/src/java/org/apache/poi/ss/usermodel/Chart.java (+55 lines)
	1	/* ====================================================================
	2	Licensed to the Apache Software Foundation (ASF) under one or more
	3	contributor license agreements. See the NOTICE file distributed with
	4	this work for additional information regarding copyright ownership.
	5	The ASF licenses this file to You under the Apache License, Version 2.0
	6	(the "License"); you may not use this file except in compliance with
	7	the License. You may obtain a copy of the License at
	8
	9	http://www.apache.org/licenses/LICENSE-2.0
	10
	11	Unless required by applicable law or agreed to in writing, software
	12	distributed under the License is distributed on an "AS IS" BASIS,
	13	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
	14	See the License for the specific language governing permissions and
	15	limitations under the License.
	16	==================================================================== */
	17
	18	package org.apache.poi.ss.usermodel;
	19
	20	import java.util.List;
	21
	22	import org.apache.poi.ss.usermodel.charts.ChartData;
	23	import org.apache.poi.ss.usermodel.charts.ChartAxis;
	24	import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
	25	import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;
	26
	27	/**
	28	* High level representation of a chart.
	29	*
	30	* @author Roman Kashitsyn
	31	*/
	32	public interface Chart {
	33
	34	/**
	35	* @return an appropriate ChartDataFactory implementation
	36	*/
	37	ChartDataFactory getChartDataFactory();
	38
	39	/**
	40	* @return an appropriate ChartAxisFactory implementation
	41	*/
	42	ChartAxisFactory getChartAxisFactory();
	43
	44	/**
	45	* @return list of all chart axis
	46	*/
	47	List<? extends ChartAxis> getAxis();
	48
	49	/**
	50	* Plots specified data on the chart.
	51	*
	52	* @param data a data to plot
	53	*/
	54	void plot(ChartData data, ChartAxis... axis);
	55	}