Example: ChartObject

This example creates a chart, and then display it's title.

import com.ibm.symphony.javaapi.Application;
import com.ibm.symphony.javaapi.Constant;
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 ChartObjectExample {

	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");
			chartObject.getChart().chartWizard(trueRange, "BarDiagram",
					Constant.SYMPHONY_CHART_PLOTBY_COLUMNS, "New Chart True",
					false);
			System.out
					.println(chartObject.getChart().getChartTitle().getText());
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

}

Related information

ChartObject