Excel Releases

Provides information on the updates to the Excel Javascript API.
link - docs.microsoft.com/en-us/office/dev/add-ins/reference/requirement-sets/excel-api-requirement-sets

VersionBuildReleased All PlatformsReleased Online
1.14  Development
1.13 2021 May (Microsoft Build)2021 May
1.1213127.204082020 September (Microsoft Ignite)2020 September
1.1112527.204702020 May (Microsoft Build)2020 May
1.1011929.203062019 November (Microsoft Ignite)2019 October
1.911425.202042019 May (Microsoft Build)2019 May
1.810730.201022018 September (Microsoft Ignite)2018 September
1.79001.21712018 May (Microsoft Build)2018 April
1.68201.20012017 September2017 April
1.58067.2072017 September2017 March
1.47870.20242017 April2017 January
1.37369.20552017 April2015 December
1.26741.20882015 December2015 September
1.14266.10012015 September2014 March
1.0 2012 December2012 August

Preview / Development

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-preview-apis
link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-online-requirement-set

Excel API: 1.14

link - ??
protectionChanged event

Excel API: 1.13

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-13-requirement-set
worksheet - onFormulaChanged event - enables you to manage state more efficiently with add-ins that use custom functions
InsertWorksheetsFromBase64 API saves developers time by easily bringing JSON data into Excel and leveraging pre-formatted templates.
Range.getDirectDependents helps audit formulas and content in user workbooks.
PivotLayout - support for alt text and empty cell management.

Excel API: 1.12

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-12-requirement-set
Tracking dynamic arrays
Finding a formula's direct precedents

Excel API: 1.11

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-11-requirement-set
Save and Close
Insert Workbook
Page Layout

Excel API: 1.10

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-10-requirement-set
onCalculated event
Group / Ungroup

Excel API: 1.9

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-9-requirement-set
Shapes - Insert, position and format images, geometric shapes and text boxes
Tables, AutoFilter - Adds filters to ranges
Cells, Areas - support for discontinuous ranges
Cells, Special Cells - Get cells containing dates, comments or formulas within a range
Cells, Range Formatting
Cells, Copy Paste - Copy values, formats and formulas from one range to another
Worksheets, Find - find values or formulas within a range and on a worksheet
Charts - New chart types, maps, box and whisker, waterfall, sunburst, pareto and funnel
Formulas, Calculation - greater control
Set Format to Chart Point(s), Subtitle
Category Axis
Display Unit
ChartSeries Add/Delete/Modification
Data validation (API to be updated..)
Comments / Notes
Custom Functions - any return type
Custom Functions - optional parameters
Custom Functions - namespace no longer required
Custom Functions - id parameter is required
Custom Functions - get the calling address of your function call

Excel API: 1.8

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-8-requirement-set
Only available to Office 365 subscription users.
Pivot Tables aggregation
Data Validation
Charts - legend
Charts - trendline
Charts - plot area
Chart - onActivated
Chart - onDeactivated
ChartCollection - onAdded
ChartCollection - onDeleted
ChartCollection - onActivated
ChartCollection - onDeactivated
Worksheet - onDataChanged - Occurs when data changed on a specific worksheet.
Worksheet - onSelectionChanged - Occurs when the selection changed on a specific worksheet.
Worksheet - onActivated - Occurs when the worksheet is activated.
Worksheet - onDeactivated - Occurs when the worksheet is deactivated.
WorksheetCollection - onAdded -
WorksheetCollection - onDeleted -
WorksheetCollection - onActivated - Occurs when any worksheet in the workbook is activated.
WorksheetCollection - onDeactivated - Occurs when any worksheet in the workbook is deactivated.
WorksheetCollection - onCalculated
Table - onChanged - Occurs when data changed on a specific table.
Table - onSelectionChanged - Occurs when the selection changed on a specific table.
TableCollection - onSelectionChanged - Occurs when the selection changed on a specific table.

Excel API: 1.7

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-7-requirement-set
Only available to Office 365 subscription users.
Workbook Name
Cell Styles for ranges (built-in and custom)
Hyperlinks add or modify
Gridlines (toggle)
Tab Color
Text Orientation
Worksheet Headings
Password protection (including workbook structure)
Workbook protection
New Range Functions
Freeze Rows and Columns
Text Orientation for a Range
Access built-in document properties
Create and manage custom document properties
Copy data and formats from one worksheet to another
Ranges - get surrounding region
Ranges - get a resized range
Charts - create a line chart
Charts - add a data series to a chart,
Charts - set the chart title
Charts - add an axis title
Charts - add display unit
Charts - add a trendline with moving average
Charts - change a trendline to linear
TableCollection - onChanged - Occurs when data changed on any table in a workbook, or a worksheet.

Excel API: 1.6

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-6-requirement-set
Only available to Office 365 subscription users.
Conditional Formatting (color scale, data bar, icon set, custom)
Range calculation
Worksheet calculation
Document.getFileAsync method available across all platforms

Excel API: 1.5

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-5-requirement-set
Only available to Office 365 subscription users.
Custom XML Parts
UsedRange (getSurroundingRegion)
getFirst and getLast methods (Worksheets, Tables, Charts)
getNext and getPrevious methods (Worksheets, Tables)
getCount (Worksheets, Tables)
getNextColumn and getPreviousColumn on table columns
getRange (address: string)

Excel API: 1.4

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-4-requirement-set
Only available to Office 365 subscription users.
F9 Recalc bug fixed
assessing ranges more flexibly with new accessor functions
Table Enhancements (set table column name, add column to end, add multiple rows at once)
getItemOrNullObject method (Worksheets, Tables, TableColumns, Settings, PivotTables)
Named Items (write)
Named Item Enhancements (properties: scope, comment, worksheet. Methods: add, addFormulaLocal)
Event Handlers
Event Management - under the Excel namespace ?
Settings Enhancements

Excel API: 1.3

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-3-requirement-set
Only available to Office 365 subscription users.
Dialogs were introduced.
Access Built-in and Custom Document Properties
Pivot Table Refresh
Range Filtered View
Range and Table as Image

Excel API: 1.2

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-2-requirement-set
Only available to Office 365 subscription users.
Commands were introduced
Worksheet Functions (300+)
R1C1 Reference Style
Merge Cells
Page Layout
Adjust Row Height
Adjust Column Width
Workbook.OnSelectionChanged event

Excel API: 1.1

link - docs.microsoft.com/en-gb/office/dev/add-ins/reference/requirement-sets/excel-api-1-1-requirement-set
Excel 2016 and Excel Online
RequestContext with a dedicated namespace.
More Chart enhancements
More Table enhancements
More Range enhancements
Named Items (read)
Number Formatting
Table Creation
Chart Creation
Cell Formatting
Range Values and Editing
File Properties
Navigate to locations and objects

Excel API: 1.0

Excel 2013
Async Callbacks in a common Office namespace.
Data Binding (tables and named ranges)
Document Bindings
Reading and writing within worksheets
Events - Workbook, active cell selection
Events - Workbook, active cell selection within a binding
Events - Workbook, values change within a binding
Events - When persisted settings change

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext