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 chanages 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)