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
Współpracuj z nami w serwisie GitHub
Źródło tej zawartości można znaleźć w witrynie GitHub, gdzie można również tworzyć i przeglądać problemy i żądania ściągnięcia. Więcej informacji znajdziesz w naszym przewodniku dla współtwórców.