- Custom XML parts: Allows you to add and manage custom XML data. Use custom XML to store information needed to understand state of the add-in, drive workflow and business logic.
- Conditional formatting: Allows you to quickly highlight important information in a spreadsheet using built-in rules and custom formulas. Use this feature to help users visually explore and analyze data, detect critical issues, and identify patterns and trends.
Expanded support for the Document.getFileAsync API
The Document.getFileAsync method, which you can use in your Excel add-in to download the current workbook, is now available across all supported platforms (Windows, Excel Online, Mac, and iPad). This enables you to retrieve the Excel workbook content and carry out post processing such as back-up, format conversion, etc.
New APIs available in public preview (beta)
With the new APIs that are available in public preview, you can do things such as create a line chart, add a data series to a chart, set the chart title, add an axis title, add display unit, add a trendline with moving average, change a trendline to linear, and more.
Perform validation of input data
New data validation APIs will allow setting up new range data validation rules (drop-down buttons) based on pre-defined list, formulas, date, time or custom values, manage input and error messages.
Customize the appearance of worksheets and ranges
With the new APIs that are available in public preview, you can customize the appearance of worksheets in multiple ways:
- Freeze panes to keep specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your worksheet contains headers, you might freeze that row so that the column headers will remain visible as you scroll down the worksheet.
- Set the visibility of gridlines in a worksheet.
- Modify worksheet tab color.
- Add worksheet headings.
With the new APIs that are available in public preview, you can customize the appearance of ranges in multiple ways:
- Set the cell style for a range to ensure sure that all cells in the range have consistent formatting. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. Use any of Excel’s built-in cell styles or create your own custom cell style.
- Set the text orientation for a range.
- Add or modify a hyperlink on a range that links to another location in the workbook or to an external location.
Manage document properties
With the new APIs that are available in public preview, you can access built-in document properties and also create and manage custom document properties to store state of the workbook and drive workflow and business logic.
Copy the data and format of from one worksheet to a new worksheet within the same workbook using simple worksheet copy API and reduce the amount of data transfer needed.
Handle ranges with ease
With the new APIs that are available in public preview, you can do things such as get the surrounding region, get a resized range, and more. These APIs should make tasks like range manipulation and addressing much more efficient.
Note: To access APIs that are in public preview, you must use the beta library of the Office.js CDN: https://appsforoffice.microsoft.com/lib/beta/hosted/office.js along with Excel Online or latest version of Excel monthly channel version.
Want to learn more?
Additionally, you can try out the new API features by using the built-in code snippets that are available in Script Lab. In Script Lab, you’ll find samples that use preview APIs listed in the Preview APIs category:
We encourage you to try out the new APIs and tell us what you think. You can post questions about the APIs on StackOverflow (with the office-js tag), make suggestions for the docs on GitHub, or suggest new API features on UserVoice.