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
Collabora con noi su GitHub
L'origine di questo contenuto è disponibile in GitHub, in cui è anche possibile creare ed esaminare i problemi e le richieste pull. Per ulteriori informazioni, vedere la guida per i collaboratori.