Example:
//Instantiating a Workbook object $workbook = new cells\Workbook(); //Adding a new worksheet to the Excel object $sheetIndex = $workbook->getWorksheets()->add(); //Obtaining the reference of the newly added worksheet by passing its sheet index $worksheet = $workbook->getWorksheets()->get($sheetIndex); $cells = $worksheet->getCells(); $cells->get("A1")->putValue(50); $cells->get("A2")->putValue(100); $cells->get("A3")->putValue(150); $cells->get("A4")->putValue(200); $cells->get("B1")->putValue(60); $cells->get("B2")->putValue(32); $cells->get("B3")->putValue(50); $cells->get("B4")->putValue(40); $cells->get("C1")->putValue("Q1"); $cells->get("C2")->putValue("Q2"); $cells->get("C3")->putValue("Y1"); $cells->get("C4")->putValue("Y2"); //Adding a chart to the worksheet $chartIndex = $worksheet->getCharts()->add(cells\ChartType::COLUMN, 5, 0, 15, 5); //Accessing the instance of the newly added 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");
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) | → inherited from CollectionBase |
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) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | get(index) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | getSeriesByOrder(order) | |
Gets the |
||
function | indexOf(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | iterator() | → inherited from CollectionBase |
function | removeAt(index) | |
Remove at a series at the specific index. |
Property Getters/Setters Detail |
---|
getCategoryData/setCategoryData : String | |
function getCategoryData() / function setCategoryData(value) |
getSecondCatergoryData/setSecondCatergoryData : String | |
function getSecondCatergoryData() / function setSecondCatergoryData(value) |
getSecondCategoryData/setSecondCategoryData : String | |
function getSecondCategoryData() / function setSecondCategoryData(value) |
isColorVaried/setColorVaried : boolean | |
function isColorVaried() / function setColorVaried(value) |
getCount : Number | |
function getCount() |
get : Series | |
function get(index) |
index
- The zero based index of the element.Method Detail |
---|
getSeriesByOrder | |
function getSeriesByOrder(order) |
order: Number
- The order of seriesremoveAt | |
function removeAt(index) |
index: Number
- The index.changeSeriesOrder | |
function changeSeriesOrder(sourceIndex, destIndex) |
sourceIndex: Number
- The current indexdestIndex: Number
- The dest indexaddR1C1 | |
function 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.add | |
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.clear | |
function clear() |
iterator | |
function iterator() |
get | |
function get(index) |
contains | |
function contains(value) |
add | |
function add(value) |
indexOf | |
function indexOf(value) |