java.lang.Object
CollectionBase
com.aspose.cells.SeriesCollection
- All Implemented Interfaces:
- com.aspose.cells.c.b.a.a.a.c.b.e
public class SeriesCollection
- extends CollectionBase
Encapsulates a collection of Series objects.
Example:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Excel object
int sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet 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
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
Chart 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("C:\\book1.xls");
Property Getters/Setters Summary |
java.lang.String | getCategoryData() | |
void | setCategoryData(java.lang.String 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}").
|
int | getCount() | → inherited from com.aspose.cells.CollectionBase |
| |
boolean | isColorVaried() | |
void | setColorVaried(boolean value) | |
|
Represents if the color of points is varied.
|
java.lang.String | getSecondCatergoryData() | |
void | setSecondCatergoryData(java.lang.String 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.
|
Series | get(int index) | |
|
Gets the Series element at the specified index.
|
Method Summary |
int | add(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. |
int | add(java.lang.String area, boolean isVertical) | |
Adds the SeriesCollection collection to a chart.
|
int | addR1C1(java.lang.String area, boolean isVertical) | |
Adds the SeriesCollection collection to a chart.
|
void | changeSeriesOrder(int sourceIndex, int destIndex) | |
Directly chanages the orders of the two series.
|
void | clear() | → inherited from com.aspose.cells.CollectionBase |
|
boolean | contains(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. |
java.lang.Object | get(int index) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. |
int | indexOf(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. |
java.util.Iterator | iterator() | → inherited from com.aspose.cells.CollectionBase |
|
void | removeAt(int index) | |
Remove at a series at the specific index.
|
Property Getters/Setters Detail |
getCategoryData/setCategoryData | |
public java.lang.String getCategoryData() / public void setCategoryData(java.lang.String 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}").
getSecondCatergoryData/setSecondCatergoryData | |
public java.lang.String getSecondCatergoryData() / public void setSecondCatergoryData(java.lang.String 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.
isColorVaried/setColorVaried | |
public boolean isColorVaried() / public void setColorVaried(boolean value)
|
-
Represents if the color of points is varied.
getCount | → inherited from com.aspose.cells.CollectionBase |
public int getCount()
|
-
get | |
public Series get(int index)
|
-
Gets the Series element at the specified index.
- Parameters:
index
- The zero based index of the element.
- Returns:
- The element at the specified index.
removeAt | |
public void removeAt(int index) |
-
Remove at a series at the specific index.
- Parameters:
index
- The index.
changeSeriesOrder | |
public void changeSeriesOrder(int sourceIndex, int destIndex) |
-
Directly chanages the orders of the two series.
- Parameters:
sourceIndex
- The current indexdestIndex
- The dest index
addR1C1 | |
public int addR1C1(java.lang.String area, boolean isVertical) |
-
Adds the SeriesCollection collection to a chart.
If set data on contiguous cells, use colon to seperate them.For example, R[1]C[1]:R[3]C[2].
If set data on contiguous cells, use comma to seperate them.For example,R[1]C[1],R[3]C[2].- Parameters:
area
- Specifies values from which to plot the data seriesisVertical
- Specifies whether to plot the series from a range of cell values by row or by column.
- Returns:
- Return the first index of the added ASeries in the NSeries.
add | |
public int add(java.lang.String area, boolean isVertical) |
-
Adds the SeriesCollection collection to a chart.
If set data on contiguous cells, use colon to seperate them.For example, C2:C5.
If set data on non contiguous cells, use comma to seperate them.For example, C2,D5.- Parameters:
area
- Specifies values from which to plot the data seriesisVertical
- Specifies whether to plot the series from a range of cell values by row or by column.
- Returns:
- Return the first index of the added ASeries in the NSeries.
clear | → inherited from com.aspose.cells.CollectionBase |
public void clear() |
-
iterator | → inherited from com.aspose.cells.CollectionBase |
public java.util.Iterator iterator() |
-
get | → inherited from com.aspose.cells.CollectionBase |
public java.lang.Object get(int index) |
- Reserved for internal use.
contains | → inherited from com.aspose.cells.CollectionBase |
public boolean contains(java.lang.Object value) |
- Reserved for internal use.
add | → inherited from com.aspose.cells.CollectionBase |
public int add(java.lang.Object value) |
- Reserved for internal use.
indexOf | → inherited from com.aspose.cells.CollectionBase |
public int indexOf(java.lang.Object value) |
- Reserved for internal use.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.