Example:
//Instantiating a Workbook object var workbook = new aspose.cells.Workbook(); //Adding a new worksheet to the Excel object var sheetIndex = workbook.getWorksheets().add(); //Obtaining the reference of the newly added worksheet by passing its sheet index var worksheet = workbook.getWorksheets().get(sheetIndex); //Adding a sample value to "A1" cell worksheet.getCells().get("A1").putValue(50); //Adding a sample value to "A2" cell worksheet.getCells().get("A2").putValue(100); //Adding a sample value to "A3" cell worksheet.getCells().get("A3").putValue(150); //Adding a sample value to "A4" cell worksheet.getCells().get("A4").putValue(200); //Adding a sample value to "B1" cell worksheet.getCells().get("B1").putValue(60); //Adding a sample value to "B2" cell worksheet.getCells().get("B2").putValue(32); //Adding a sample value to "B3" cell worksheet.getCells().get("B3").putValue(50); //Adding a sample value to "B4" cell worksheet.getCells().get("B4").putValue(40); //Adding a sample value to "C1" cell as category data worksheet.getCells().get("C1").putValue("Q1"); //Adding a sample value to "C2" cell as category data worksheet.getCells().get("C2").putValue("Q2"); //Adding a sample value to "C3" cell as category data worksheet.getCells().get("C3").putValue("Y1"); //Adding a sample value to "C4" cell as category data worksheet.getCells().get("C4").putValue("Y2"); //Adding a chart to the worksheet var chartIndex = worksheet.getCharts().add(aspose.cells.ChartType.COLUMN, 5, 0, 15, 5); //Accessing the instance of the newly added chart var chart = worksheet.getCharts().get(chartIndex); //Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4" chart.getNSeries().add("A1:B4", true); //Setting the data source for the category data of NSeries chart.getNSeries().setCategoryData("C1:C4"); //Saving the Excel file workbook.save("Book1.xls");
Property Getters/Setters Summary | ||
---|---|---|
function | getCategoryData() | |
function | setCategoryData(value) | |
Gets or sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). | ||
function | getCount() | |
function | isColorVaried() | |
function | setColorVaried(value) | |
Represents if the color of points is varied. | ||
function | getSecondCategoryData() | |
function | setSecondCategoryData(value) | |
Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis. | ||
function | getSecondCatergoryData() | |
function | setSecondCatergoryData(value) | |
Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis. | ||
function | get(index) | |
Gets the |
Method Summary | ||
---|---|---|
function | add(value) | |
Reserved for internal use. |
||
function | add(area, isVertical) | |
Adds the |
||
function | addR1C1(area, isVertical) | |
Adds the |
||
function | changeSeriesOrder(sourceIndex, destIndex) | |
Directly changes the orders of the two series.
|
||
function | clear() | |
Clears the collection
|
||
function | contains(value) | |
Reserved for internal use. |
||
function | get(index) | |
Reserved for internal use. |
||
function | getSeriesByOrder(order) | |
Gets the |
||
function | indexOf(value) | |
Reserved for internal use. |
||
function | iterator() | |
function | removeAt(index) | |
Remove at a series at the specific index.
|
function getCategoryData() / function setCategoryData(value)
function getSecondCatergoryData() / function setSecondCatergoryData(value)
function getSecondCategoryData() / function setSecondCategoryData(value)
function isColorVaried() / function setColorVaried(value)
function getCount()
function get(index)
index
- The zero based index of the element.function getSeriesByOrder(order)
order: Number
- The order of seriesfunction removeAt(index)
index: Number
- The index.function changeSeriesOrder(sourceIndex, destIndex)
sourceIndex: Number
- The current indexdestIndex: Number
- The dest indexfunction addR1C1(area, isVertical)
area: String
- Specifies values from which to plot the data seriesisVertical: boolean
- Specifies whether to plot the series from a range of cell values by row or by column.function add(area, isVertical)
area: String
- Specifies values from which to plot the data seriesisVertical: boolean
- Specifies whether to plot the series from a range of cell values by row or by column.function clear()
function iterator()
function get(index)
function contains(value)
function add(value)
function indexOf(value)