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
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins