Wiki
Clone wikiAspose Java for Docx4j / Create-Charts
Aspose.Cells
// Instantiating a Workbook object Workbook workbook = new Workbook(); // Obtaining the reference of the first worksheet WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet sheet = worksheets.get(0); // Adding some sample value to cells Cells cells = sheet.getCells(); Cell cell = cells.get("A1"); cell.setValue(50); cell = cells.get("A2"); cell. setValue (100); cell = cells.get("A3"); cell.setValue(150); cell = cells.get("B1"); cell.setValue(4); cell = cells.get("B2"); cell.setValue(20); cell = cells.get("B3"); cell.setValue(50); ChartCollection charts = sheet.getCharts(); // Adding a chart to the worksheet int chartIndex = charts.add(ChartType.PYRAMID,5,0,15,5); Chart chart = charts.get(chartIndex); // Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3" SeriesCollection serieses = chart.getNSeries(); serieses.add("A1:B3", true); // Saving the Excel file workbook.save("Chart_Aspose.xls");
Download Source Code
For More Examples, Please Visit Aspose Docs
Updated