Skip to main content

ChartCollection

Excel.ChartCollection of one worksheet. Import from @reductoai/xlsx/officejs.

ChartCollection properties

ChartCollection.add()

A chart of type over sourceData, laid out as Excel’s Insert Chart does: labels in the first row and columns name the series and categories. It sits one column right of the data.

ChartCollection.getCount()

ChartCollection.getItem()

ChartCollection.getItemAt()

ChartCollection.getItemOrNullObject()

ExcelChart

Excel.Chart: a chart frame on a worksheet. Edits apply at once. Import from @reductoai/xlsx/officejs.

ExcelChart properties

ExcelChart.activate()

ExcelChart.delete()

Removes the frame and its chart part; the handle stops working.

ExcelChart.getDataTable()

ExcelChart.getDataTableOrNullObject()

ExcelChart.set()

Sets several properties at once; a navigation member takes a nested batch.

ExcelChart.setData()

Plots sourceData again; the chart keeps its type, title and legend.

ExcelChart.setPosition()

Top-left at startCell; with endCell, the bottom-right at that cell’s far corner.

ExcelChartSeriesCollection

Excel.ChartSeriesCollection. Import from @reductoai/xlsx/officejs.

ExcelChartSeriesCollection properties

ExcelChartSeriesCollection.add()

An empty series; give it cells with setValues.

ExcelChartSeriesCollection.getCount()

ExcelChartSeriesCollection.getItemAt()

ExcelChartSeries

Excel.ChartSeries: the shared series handle plus Excel’s range setters. Import from @reductoai/xlsx/officejs.

ExcelChartSeries properties

ExcelChartSeries.delete()

Remove this series from its plot. The handle is dead afterwards.

ExcelChartSeries.getDimensionDataSourceString()

ExcelChartSeries.getDimensionDataSourceType()

ExcelChartSeries.getDimensionValues()

ExcelChartSeries.moveTo()

Move this series to chart-space position index (the order chart.series lists). Paint stacking, legend order and the automatic accent cycle follow. A series never changes plot families. The frozen index snapshot does not renumber; re-read chart.series.

ExcelChartSeries.set()

Sets several properties at once; a navigation member takes a nested batch.

ExcelChartSeries.setBubbleSizes()

A bubble series’ sizes come from sourceData.

ExcelChartSeries.setName()

Extension: the series name comes from a cell.

ExcelChartSeries.setValues()

The values come from sourceData.

ExcelChartSeries.setXAxisValues()

The categories, or a scatter’s x values, come from sourceData.

ExcelChartTitle

Excel.ChartTitle. Import from @reductoai/xlsx/officejs.

ExcelChartTitle properties

ExcelChartTitle.delete()

ExcelChartTitle.getSubstring()

The font of length characters from start (to the end when omitted).

ExcelChartTitle.set()

Sets several properties at once; a navigation member takes a nested batch.

ExcelChartTitle.setFormula()

Shows a cell’s text (=Sheet1!$A$1); a string without ”=” is the title’s own text.