Excel Releases

Provides information on the updates to the Excel Javascript API.
Github Documentation - https://github.com/OfficeDev/office-js-docs-reference
Microsoft API Reference - https://docs.microsoft.com/en-gb/javascript/api/overview/office?view=office-js
Microsoft API Requirements - https://docs.microsoft.com/en-us/office/dev/add-ins/reference/requirement-sets/excel-api-requirement-sets
Stack Overflow - https://stackoverflow.com/questions/tagged/office-js
Uservoice Feedback - https://officespdev.uservoice.com/


VersionBuildReleased All PlatformsReleased Online
1.10  Development
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

Development

Save and Close
Insert Workbook
Page Layout
Undo/Redo


Excel API 1.10

onCalculated event
Group / Ungroup


Excel API 1.9

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
ChartTrendline
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
Slicers
Workbook.getActiveSlicer
Worksheet.Slicers.Add


Excel API 1.8

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

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

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

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)
getRangeR1C1
getCount (Worksheets, Tables)
getActiveWorksheet
getNextColumn and getPreviousColumn on table columns
getRange (address: string)
getBoundingRange


Excel API 1.4

Only available to Office 365 subscription users.
F9 Recalc bug fixed
suspendCalculationUnitlNextSync
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)
Sheet.Names.Add
Workbook.Names.Add
Event Handlers
Event Management - under the Excel namespace ?
Settings Enhancements


Excel API 1.3

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

Only available to Office 365 subscription users.
Commands were introduced
Protection
Worksheet Functions (300+)
context.workbook.functions.abs
Sort
Filter
R1C1 Reference Style
Merge Cells
Page Layout
Adjust Row Height
Adjust Column Width
Autofit
Chart.getImage()
Range.getUsedRange(valuesOnly)
Workbook.OnSelectionChanged event


Excel API 1.1

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
Settings
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


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