public final class ExcelChartCollection extends ExcelDrawingCollectionImpl<ExcelChart>
chart
s in the worksheet.ExcelWorksheet charts
Modifier and Type | Method and Description |
---|---|
<T extends ExcelChart> |
add(AnchorCell positionFrom,
AnchorCell positionTo,
Class<T> classType)
Adds a new chart to the worksheet which moves and sizes with cells.
|
<T extends ExcelChart> |
add(AnchorCell positionFrom,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
<T extends ExcelChart> |
add(ChartGrouping chartGrouping,
AnchorCell positionFrom,
AnchorCell positionTo,
Class<T> classType)
Adds a new chart to the worksheet which moves and sizes with cells.
|
<T extends ExcelChart> |
add(ChartGrouping chartGrouping,
AnchorCell positionFrom,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
<T extends ExcelChart> |
add(ChartGrouping chartGrouping,
double left,
double top,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
|
<T extends ExcelChart> |
add(ChartGrouping chartGrouping,
String positionFromCell,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
<T extends ExcelChart> |
add(ChartGrouping chartGrouping,
String positionFromCell,
String positionToCell,
Class<T> classType)
Adds a new chart to the worksheet which moves and sizes with cells.
|
ExcelChart |
add(ChartType chartType,
AnchorCell positionFrom,
AnchorCell positionTo)
Adds a new chart to the worksheet which moves and sizes with cells.
|
ExcelChart |
add(ChartType chartType,
AnchorCell positionFrom,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
ExcelChart |
add(ChartType chartType,
ChartGrouping chartGrouping,
AnchorCell positionFrom,
AnchorCell positionTo)
Adds a new chart to the worksheet which moves and sizes with cells.
|
ExcelChart |
add(ChartType chartType,
ChartGrouping chartGrouping,
AnchorCell positionFrom,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
ExcelChart |
add(ChartType chartType,
ChartGrouping chartGrouping,
double left,
double top,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
|
ExcelChart |
add(ChartType chartType,
ChartGrouping chartGrouping,
String positionFromCell,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
ExcelChart |
add(ChartType chartType,
ChartGrouping chartGrouping,
String positionFromCell,
String positionToCell)
Adds a new chart to the worksheet which moves and sizes with cells.
|
ExcelChart |
add(ChartType chartType,
double left,
double top,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
|
ExcelChart |
add(ChartType chartType,
String positionFromCell,
double width,
double height,
LengthUnit unit)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
ExcelChart |
add(ChartType chartType,
String positionFromCell,
String positionToCell)
Adds a new chart to the worksheet which moves and sizes with cells.
|
<T extends ExcelChart> |
add(double left,
double top,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
|
<T extends ExcelChart> |
add(String positionFromCell,
double width,
double height,
LengthUnit unit,
Class<T> classType)
Adds a new chart to the worksheet which moves but doesn't size with cells.
|
<T extends ExcelChart> |
add(String positionFromCell,
String positionToCell,
Class<T> classType)
Adds a new chart to the worksheet which moves and sizes with cells.
|
<T extends ExcelChart> |
getChart(int index)
Gets the chart at the specified index and casts it to the specified chart subtype deriving from
ExcelChart . |
add, add, addAll, addAll, addCopy, clear, contains, containsAll, get, indexOf, isEmpty, iterator, move, remove, remove, removeAll, set, size, toArray, toArray
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
addExcelDrawing, addExcelDrawing, getExcelDrawingCollectionWorksheet, getLastRowColumn, getObjectIterable
equals, hashCode, lastIndexOf, listIterator, listIterator, replaceAll, retainAll, sort, spliterator, subList
parallelStream, removeIf, stream
public <T extends ExcelChart> T add(AnchorCell positionFrom, AnchorCell positionTo, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
T
- The type of the chart deriving from ExcelChart
type.positionFrom
- The chart's position (top-left corner).positionTo
- The chart's end position (bottom-right corner).classType
- Class of T
public <T extends ExcelChart> T add(AnchorCell positionFrom, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
T
- The type of the chart deriving from ExcelChart
type.positionFrom
- The chart's position.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(ChartGrouping chartGrouping, AnchorCell positionFrom, AnchorCell positionTo, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
T
- The type of the chart deriving from ExcelChart
type.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFrom
- The chart's position (top-left corner).positionTo
- The chart's end position (bottom-right corner).classType
- Class of T
public <T extends ExcelChart> T add(ChartGrouping chartGrouping, AnchorCell positionFrom, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
T
- The type of the chart deriving from ExcelChart
type.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFrom
- The chart's position.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(ChartGrouping chartGrouping, double left, double top, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.FREE_FLOATING
.
T
- The type of the chart deriving from ExcelChart
type.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).left
- The distance of the left edge of the chart from the left edge of the worksheet.top
- The distance of the top edge of the chart from the top edge of the worksheet.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(ChartGrouping chartGrouping, String positionFromCell, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
T
- The type of the chart deriving from ExcelChart
type.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFromCell
- The chart's position (for example, "A1").width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(ChartGrouping chartGrouping, String positionFromCell, String positionToCell, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
T
- The type of the chart deriving from ExcelChart
type.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFromCell
- The chart's position (top-left corner) (for example, "A1").positionToCell
- The chart's end position (bottom-right corner) (for example, "B2").classType
- Class of T
public ExcelChart add(ChartType chartType, AnchorCell positionFrom, AnchorCell positionTo)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
chartType
- Type of the chart.positionFrom
- The chart's position (top-left corner).positionTo
- The chart's end position (bottom-right corner).public ExcelChart add(ChartType chartType, AnchorCell positionFrom, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
chartType
- Type of the chart.positionFrom
- The chart's position.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, ChartGrouping chartGrouping, AnchorCell positionFrom, AnchorCell positionTo)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
chartType
- Type of the chart.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFrom
- The chart's position (top-left corner).positionTo
- The chart's end position (bottom-right corner).public ExcelChart add(ChartType chartType, ChartGrouping chartGrouping, AnchorCell positionFrom, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
chartType
- Type of the chart.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFrom
- The chart's position.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, ChartGrouping chartGrouping, double left, double top, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.FREE_FLOATING
.
chartType
- Type of the chart.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).left
- The distance of the left edge of the chart from the left edge of the worksheet.top
- The distance of the top edge of the chart from the top edge of the worksheet.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, ChartGrouping chartGrouping, String positionFromCell, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
chartType
- Type of the chart.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFromCell
- The chart's position (for example, "A1").width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, ChartGrouping chartGrouping, String positionFromCell, String positionToCell)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
chartType
- Type of the chart.chartGrouping
- The chart's series grouping (clustered, stacked or 100% stacked).positionFromCell
- The chart's position (top-left corner) (for example, "A1").positionToCell
- The chart's end position (bottom-right corner) (for example, "B2").public ExcelChart add(ChartType chartType, double left, double top, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.FREE_FLOATING
.
chartType
- Type of the chart.left
- The distance of the left edge of the chart from the left edge of the worksheet.top
- The distance of the top edge of the chart from the top edge of the worksheet.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, String positionFromCell, double width, double height, LengthUnit unit)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
chartType
- Type of the chart.positionFromCell
- The chart's position (for example, "A1").width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.public ExcelChart add(ChartType chartType, String positionFromCell, String positionToCell)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
chartType
- Type of the chart.positionFromCell
- The chart's position (top-left corner) (for example, "A1").positionToCell
- The chart's end position (bottom-right corner) (for example, "B2").public <T extends ExcelChart> T add(double left, double top, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.FREE_FLOATING
.
T
- The type of the chart deriving from ExcelChart
type.left
- The distance of the left edge of the chart from the left edge of the worksheet.top
- The distance of the top edge of the chart from the top edge of the worksheet.width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(String positionFromCell, double width, double height, LengthUnit unit, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE
.
T
- The type of the chart deriving from ExcelChart
type.positionFromCell
- The chart's position (for example, "A1").width
- The chart's width.height
- The chart's height.unit
- The length unit in which all length parameters are specified.classType
- Class of T
public <T extends ExcelChart> T add(String positionFromCell, String positionToCell, Class<T> classType)
ExcelDrawing.getPosition()
.getMode()
of a newly added chart will be PositioningMode.MOVE_AND_SIZE
.
T
- The type of the chart deriving from ExcelChart
type.positionFromCell
- The chart's position (top-left corner) (for example, "A1").positionToCell
- The chart's end position (bottom-right corner) (for example, "B2").classType
- Class of T
public <T extends ExcelChart> T getChart(int index)
ExcelChart
.The
- chart subtype deriving from ExcelChart
to cast the chart to.index
- The zero-based index of the chart to get.T
type.
This method serves as a utility method for casting.IndexOutOfBoundsException
- index
is less than 0 or is equal to or greater than {ExcelChart}.Count
.ClassCastException
- A chart at the specified index cannot be cast to type T
.© GemBox Ltd. — All rights reserved.