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