Example: Chart

This example creates a chart for range(A10:E15), and then displays the chart title.

import com.ibm.symphony.javaapi.Application;
import com.ibm.symphony.javaapi.Constant;
import com.ibm.symphony.javaapi.spreadsheet.Chart;
import com.ibm.symphony.javaapi.spreadsheet.ChartObject;
import com.ibm.symphony.javaapi.spreadsheet.ChartObjects;
import com.ibm.symphony.javaapi.spreadsheet.Range;
import com.ibm.symphony.javaapi.spreadsheet.Sheet;
import com.ibm.symphony.javaapi.spreadsheet.Sheets;
import com.ibm.symphony.javaapi.spreadsheet.Spreadsheet;
import com.ibm.symphony.javaapi.spreadsheet.Spreadsheets;

public class ChartExample {

	public void example() {
		try {
			Spreadsheets spreadsheets = Application.getInstance()
					.getSpreadsheets();
			Spreadsheet spreadsheet = spreadsheets.openSpreadsheet(
					"d:\\Scenario\\Chart.ods", true);
			Sheets sheets = spreadsheet.getSheets();
			Sheet sheet = sheets.item(1);

			ChartObjects chartObjects = sheet.getChartObjects();
			ChartObject chartObject = chartObjects.add("NewChartObject", 6000,
					5000, 6000, 4000);
			Range trueRange = spreadsheet.getActiveSheet().range("A1:E15");
			Chart chart = chartObject.getChart();
			chart.chartWizard(trueRange,
					Constant.SYMPHONY_CHART_PIEDIAGRAM,
					Constant.SYMPHONY_CHART_PLOTBY_COLUMNS, "New Chart True",
					false);
			System.out
					.println(chartObject.getChart().getChartTitle().getText());
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

}

Related information

Chart