Addition

• - Supports worksheet protection together with all advanced protection options Excel offers. - see details in our API Reference.

Additions

• - Enabled developers to leverage over 300 Excel functions and formulas directly from JavaScript.- see details in our API Reference.

Addtions

• -Supports analyzing data with advanced filtering in Excel. - see details in our API Reference.

Addtions

• -Supports analyzing data with advanced sorting in Excel for both Range and Table. - see details in our API Reference.

Addtions

• -Adds support to convert a table into a normal range of cells while data is preserved. - see details in our API Reference.

Addtions

• - Adds support to render a chart as a base64-encoded image by scaling the chart to fit the specified dimensions. - see details in our API Reference.

Addtions

• - Supports merge and unmerge cells to improve report layout. - see details in our API Reference.

Changes

• - getUsedRange() now supports a new optional parameter valuesOnly, When true only cells that currently have values are considered used cells. - see details in our API Reference.

Addtions

• - Adds new properties rowHeight, columnWidth as well as methods autofitRows() and autofitColumns() to adjust row height and column width. - see details in our API Reference.

Addition

• - Add application object that represents the Microsoft Word application. This currently enables you to create a new Word document in memory. - see details in our API Reference.

Addition

• - Adds new parameter rangeLocation to Range.getRange() method to get a range with an origin at either the beginning or end of an body object. - see details in our API Reference.
• - Add new method Range.splitTextRanges() that splits the range into child ranges by using delimiters. - see details in our API Reference.
• - getNextTextRange() is added to support getting the next text range by using delimiters. - see details in our API Reference.
• - Add new method Range.compareLocationWith() that compares this range's location with another range's location. - see details in our API Reference.
• - Add new method Range.intersectWith() that shrinks the range to the intersection of the range with another range. - see details in our API Reference.

Addition

• - Adds new parameter rangeLocation to Body.getRange() method to get a body with an origin at either the beginning or end of an body object. - see details in our API Reference.
• - Add new method Body.splitTextRanges() that splits the body into child ranges by using delimiters. - see details in our API Reference.

Addition

• - Adds new parameter rangeLocation to contentControl.getRange() method to get a content control with an origin at either the beginning or end of an body object. - see details in our API Reference.
• - Add new method contentControl.splitTextRanges() that splits the content control into child ranges by using delimiters. - see details in our API Reference.

Addition

• - Adds new parameter rangeLocation to Paragraph.getRange() method to get a paragraph with an origin at either the beginning or end of an body object. - see details in our API Reference.
• - Add new method Paragraph.splitTextRanges() that splits the paragraph into child ranges by using delimiters. - see details in our API Reference.

Addition

• - Adds new method SectionCollection.getItem() to get a section object by its index in the collection. - see details in our API Reference.

Addition

• - Adds new method ParagraphCollection.getItem() to get a section object by its index in the collection. - see details in our API Reference.

Addition

• - Adds new method SearchResultCollection.getItem() to get a section object by its index in the collection. - see details in our API Reference.