編輯

What's new in Excel JavaScript API 1.15

  • 發行項

The ExcelApi 1.15 added an a method to locate all the dependent cells of a formula, methods to retrieve information about the data source of both ChartSeries and PivotTable objects to support the copy experience, and additional control when adding data to tables to support co-authoring.

API list

The following table lists the APIs in Excel JavaScript API requirement set 1.15. To view API reference documentation for all APIs supported by Excel JavaScript API requirement set 1.15 or earlier, see Excel APIs in requirement set 1.15 or earlier.

Class Fields Description
ChartSeries getDimensionDataSourceString(dimension: Excel.ChartSeriesDimension) Gets the string representation of the data source of the chart series.
getDimensionDataSourceType(dimension: Excel.ChartSeriesDimension) Gets the data source type of the chart series.
PivotTable getDataSourceString() Returns the string representation of the data source for the PivotTable.
getDataSourceType() Gets the type of the data source for the PivotTable.
PivotTableScopedCollection getFirstOrNullObject() Gets the first PivotTable in the collection.
Range getDependents() Returns a WorkbookRangeAreas object that represents the range containing all the dependent cells of a specified range in the same worksheet or across multiple worksheets.
Shape displayName Gets the display name of the shape.

See also