What's new in Excel JavaScript API 1.9
More than 500 new Excel APIs were introduced with the 1.9 requirement set. The first table provides a concise summary of the APIs, while the subsequent table gives a detailed list.
Feature area | Description | Relevant objects |
---|---|---|
Shapes | Insert, position, and format images, geometric shapes and text boxes. | ShapeCollection Shape GeometricShape Image |
Auto Filter | Add filters to ranges. | AutoFilter |
Areas | Support for discontinuous ranges. | RangeAreas |
Special Cells | Get cells containing dates, comments, or formulas within a range. | Range |
Find | Find values or formulas within a range or worksheet. | RangeWorksheet |
Copy and Paste | Copy values, formats, and formulas from one range to another. | Range |
Calculation | Greater control over the Excel calculation engine. | Application |
New Charts | Explore our new supported chart types: maps, box and whisker, waterfall, sunburst, pareto. and funnel. | Chart |
RangeFormat | New capabilities with range formats. | Range |
API list
The following table lists the APIs in Excel JavaScript API requirement set 1.9. To view API reference documentation for all APIs supported by Excel JavaScript API requirement set 1.9 or earlier, see Excel APIs in requirement set 1.9 or earlier.
Class | Fields | Description |
---|---|---|
Application | calculationEngineVersion | Returns the Excel calculation engine version used for the last full recalculation. |
calculationState | Returns the calculation state of the application. | |
iterativeCalculation | Returns the iterative calculation settings. | |
suspendScreenUpdatingUntilNextSync() | Suspends screen updating until the next context.sync() is called. |
|
AutoFilter | apply(range: Range | string, columnIndex?: number, criteria?: Excel.FilterCriteria) | Applies the AutoFilter to a range. |
clearCriteria() | Clears the filter criteria and sort state of the AutoFilter. | |
criteria | An array that holds all the filter criteria in the autofiltered range. | |
enabled | Specifies if the AutoFilter is enabled. | |
getRange() | Returns the Range object that represents the range to which the AutoFilter applies. |
|
getRangeOrNullObject() | Returns the Range object that represents the range to which the AutoFilter applies. |
|
isDataFiltered | Specifies if the AutoFilter has filter criteria. | |
reapply() | Applies the specified AutoFilter object currently on the range. | |
remove() | Removes the AutoFilter for the range. | |
CellBorder | color | Represents the color property of a single border. |
style | Represents the style property of a single border. |
|
tintAndShade | Represents the tintAndShade property of a single border. |
|
weight | Represents the weight property of a single border. |
|
CellBorderCollection | bottom | Represents the format.borders.bottom property. |
diagonalDown | Represents the format.borders.diagonalDown property. |
|
diagonalUp | Represents the format.borders.diagonalUp property. |
|
horizontal | Represents the format.borders.horizontal property. |
|
left | Represents the format.borders.left property. |
|
right | Represents the format.borders.right property. |
|
top | Represents the format.borders.top property. |
|
vertical | Represents the format.borders.vertical property. |
|
CellProperties | address | Represents the address property. |
addressLocal | Represents the addressLocal property. |
|
hidden | Represents the hidden property. |
|
CellPropertiesFill | color | Represents the format.fill.color property. |
pattern | Represents the format.fill.pattern property. |
|
patternColor | Represents the format.fill.patternColor property. |
|
patternTintAndShade | Represents the format.fill.patternTintAndShade property. |
|
tintAndShade | Represents the format.fill.tintAndShade property. |
|
CellPropertiesFont | bold | Represents the format.font.bold property. |
color | Represents the format.font.color property. |
|
italic | Represents the format.font.italic property. |
|
name | Represents the format.font.name property. |
|
size | Represents the format.font.size property. |
|
strikethrough | Represents the format.font.strikethrough property. |
|
subscript | Represents the format.font.subscript property. |
|
superscript | Represents the format.font.superscript property. |
|
tintAndShade | Represents the format.font.tintAndShade property. |
|
underline | Represents the format.font.underline property. |
|
CellPropertiesFormat | autoIndent | Represents the autoIndent property. |
borders | Represents the borders property. |
|
fill | Represents the fill property. |
|
font | Represents the font property. |
|
horizontalAlignment | Represents the horizontalAlignment property. |
|
indentLevel | Represents the indentLevel property. |
|
protection | Represents the protection property. |
|
readingOrder | Represents the readingOrder property. |
|
shrinkToFit | Represents the shrinkToFit property. |
|
textOrientation | Represents the textOrientation property. |
|
useStandardHeight | Represents the useStandardHeight property. |
|
useStandardWidth | Represents the useStandardWidth property. |
|
verticalAlignment | Represents the verticalAlignment property. |
|
wrapText | Represents the wrapText property. |
|
CellPropertiesProtection | formulaHidden | Represents the format.protection.formulaHidden property. |
locked | Represents the format.protection.locked property. |
|
ChangedEventDetail | valueAfter | Represents the value after the change. |
valueBefore | Represents the value before the change. | |
valueTypeAfter | Represents the type of value after the change. | |
valueTypeBefore | Represents the type of value before the change. | |
Chart | activate() | Activates the chart in the Excel UI. |
pivotOptions | Encapsulates the options for a pivot chart. | |
ChartAreaFormat | colorScheme | Specifies the color scheme of the chart. |
roundedCorners | Specifies if the chart area of the chart has rounded corners. | |
ChartAxis | linkNumberFormat | Specifies if the number format is linked to the cells. |
ChartBinOptions | allowOverflow | Specifies if bin overflow is enabled in a histogram chart or pareto chart. |
allowUnderflow | Specifies if bin underflow is enabled in a histogram chart or pareto chart. | |
count | Specifies the bin count of a histogram chart or pareto chart. | |
overflowValue | Specifies the bin overflow value of a histogram chart or pareto chart. | |
type | Specifies the bin's type for a histogram chart or pareto chart. | |
underflowValue | Specifies the bin underflow value of a histogram chart or pareto chart. | |
width | Specifies the bin width value of a histogram chart or pareto chart. | |
ChartBoxwhiskerOptions | quartileCalculation | Specifies if the quartile calculation type of a box and whisker chart. |
showInnerPoints | Specifies if inner points are shown in a box and whisker chart. | |
showMeanLine | Specifies if the mean line is shown in a box and whisker chart. | |
showMeanMarker | Specifies if the mean marker is shown in a box and whisker chart. | |
showOutlierPoints | Specifies if outlier points are shown in a box and whisker chart. | |
ChartDataLabel | linkNumberFormat | Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). |
ChartDataLabels | linkNumberFormat | Specifies if the number format is linked to the cells. |
ChartErrorBars | endStyleCap | Specifies if error bars have an end style cap. |
format | Specifies the formatting type of the error bars. | |
include | Specifies which parts of the error bars to include. | |
type | The type of range marked by the error bars. | |
visible | Specifies whether the error bars are displayed. | |
ChartErrorBarsFormat | line | Represents the chart line formatting. |
ChartMapOptions | labelStrategy | Specifies the series map labels strategy of a region map chart. |
level | Specifies the series mapping level of a region map chart. | |
projectionType | Specifies the series projection type of a region map chart. | |
ChartPivotOptions | showAxisFieldButtons | Specifies whether to display the axis field buttons on a PivotChart. |
showLegendFieldButtons | Specifies whether to display the legend field buttons on a PivotChart. | |
showReportFilterFieldButtons | Specifies whether to display the report filter field buttons on a PivotChart. | |
showValueFieldButtons | Specifies whether to display the show value field buttons on a PivotChart. | |
ChartSeries | binOptions | Encapsulates the bin options for histogram charts and pareto charts. |
boxwhiskerOptions | Encapsulates the options for the box and whisker charts. | |
bubbleScale | This can be an integer value from 0 (zero) to 300, representing the percentage of the default size. | |
gradientMaximumColor | Specifies the color for maximum value of a region map chart series. | |
gradientMaximumType | Specifies the type for maximum value of a region map chart series. | |
gradientMaximumValue | Specifies the maximum value of a region map chart series. | |
gradientMidpointColor | Specifies the color for the midpoint value of a region map chart series. | |
gradientMidpointType | Specifies the type for the midpoint value of a region map chart series. | |
gradientMidpointValue | Specifies the midpoint value of a region map chart series. | |
gradientMinimumColor | Specifies the color for the minimum value of a region map chart series. | |
gradientMinimumType | Specifies the type for the minimum value of a region map chart series. | |
gradientMinimumValue | Specifies the minimum value of a region map chart series. | |
gradientStyle | Specifies the series gradient style of a region map chart. | |
invertColor | Specifies the fill color for negative data points in a series. | |
mapOptions | Encapsulates the options for a region map chart. | |
parentLabelStrategy | Specifies the series parent label strategy area for a treemap chart. | |
showConnectorLines | Specifies whether connector lines are shown in waterfall charts. | |
showLeaderLines | Specifies whether leader lines are displayed for each data label in the series. | |
splitValue | Specifies the threshold value that separates two sections of either a pie-of-pie chart or a bar-of-pie chart. | |
xErrorBars | Represents the error bar object of a chart series. | |
yErrorBars | Represents the error bar object of a chart series. | |
ChartTrendlineLabel | linkNumberFormat | Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). |
ColumnProperties | address | Represents the address property. |
addressLocal | Represents the addressLocal property. |
|
columnIndex | Represents the columnIndex property. |
|
ConditionalFormat | getRanges() | Returns the RangeAreas , comprising one or more rectangular ranges, to which the conditonal format is applied. |
DataValidation | getInvalidCells() | Returns a RangeAreas object, comprising one or more rectangular ranges, with invalid cell values. |
getInvalidCellsOrNullObject() | Returns a RangeAreas object, comprising one or more rectangular ranges, with invalid cell values. |
|
FilterCriteria | subField | The property used by the filter to do a rich filter on rich values. |
GeometricShape | id | Returns the shape identifier. |
shape | Returns the Shape object for the geometric shape. |
|
GroupShapeCollection | getCount() | Returns the number of shapes in the shape group. |
getItem(key: string) | Gets a shape using its name or ID. | |
getItemAt(index: number) | Gets a shape based on its position in the collection. | |
items | Gets the loaded child items in this collection. | |
HeaderFooter | centerFooter | The center footer of the worksheet. |
centerHeader | The center header of the worksheet. | |
leftFooter | The left footer of the worksheet. | |
leftHeader | The left header of the worksheet. | |
rightFooter | The right footer of the worksheet. | |
rightHeader | The right header of the worksheet. | |
HeaderFooterGroup | defaultForAllPages | The general header/footer, used for all pages unless even/odd or first page is specified. |
evenPages | The header/footer to use for even pages, odd header/footer needs to be specified for odd pages. | |
firstPage | The first page header/footer, for all other pages general or even/odd is used. | |
oddPages | The header/footer to use for odd pages, even header/footer needs to be specified for even pages. | |
state | The state by which headers/footers are set. | |
useSheetMargins | Gets or sets a flag indicating if headers/footers are aligned with the page margins set in the page layout options for the worksheet. | |
useSheetScale | Gets or sets a flag indicating if headers/footers should be scaled by the page percentage scale set in the page layout options for the worksheet. | |
Image | format | Returns the format of the image. |
id | Specifies the shape identifier for the image object. | |
shape | Returns the Shape object associated with the image. |
|
IterativeCalculation | enabled | True if Excel will use iteration to resolve circular references. |
maxChange | Specifies the maximum amount of change between each iteration as Excel resolves circular references. | |
maxIteration | Specifies the maximum number of iterations that Excel can use to resolve a circular reference. | |
Line | beginArrowheadLength | Represents the length of the arrowhead at the beginning of the specified line. |
beginArrowheadStyle | Represents the style of the arrowhead at the beginning of the specified line. | |
beginArrowheadWidth | Represents the width of the arrowhead at the beginning of the specified line. | |
beginConnectedShape | Represents the shape to which the beginning of the specified line is attached. | |
beginConnectedSite | Represents the connection site to which the beginning of a connector is connected. | |
connectBeginShape(shape: Excel.Shape, connectionSite: number) | Attaches the beginning of the specified connector to a specified shape. | |
connectEndShape(shape: Excel.Shape, connectionSite: number) | Attaches the end of the specified connector to a specified shape. | |
connectorType | Represents the connector type for the line. | |
disconnectBeginShape() | Detaches the beginning of the specified connector from a shape. | |
disconnectEndShape() | Detaches the end of the specified connector from a shape. | |
endArrowheadLength | Represents the length of the arrowhead at the end of the specified line. | |
endArrowheadStyle | Represents the style of the arrowhead at the end of the specified line. | |
endArrowheadWidth | Represents the width of the arrowhead at the end of the specified line. | |
endConnectedShape | Represents the shape to which the end of the specified line is attached. | |
endConnectedSite | Represents the connection site to which the end of a connector is connected. | |
id | Specifies the shape identifier. | |
isBeginConnected | Specifies if the beginning of the specified line is connected to a shape. | |
isEndConnected | Specifies if the end of the specified line is connected to a shape. | |
shape | Returns the Shape object associated with the line. |
|
PageBreak | columnIndex | Specifies the column index for the page break. |
delete() | Deletes a page break object. | |
getCellAfterBreak() | Gets the first cell after the page break. | |
rowIndex | Specifies the row index for the page break. | |
PageBreakCollection | add(pageBreakRange: Range | string) | Adds a page break before the top-left cell of the range specified. |
getCount() | Gets the number of page breaks in the collection. | |
getItem(index: number) | Gets a page break object via the index. | |
items | Gets the loaded child items in this collection. | |
removePageBreaks() | Resets all manual page breaks in the collection. | |
PageLayout | blackAndWhite | The worksheet's black and white print option. |
bottomMargin | The worksheet's bottom page margin to use for printing in points. | |
centerHorizontally | The worksheet's center horizontally flag. | |
centerVertically | The worksheet's center vertically flag. | |
draftMode | The worksheet's draft mode option. | |
firstPageNumber | The worksheet's first page number to print. | |
footerMargin | The worksheet's footer margin, in points, for use when printing. | |
getPrintArea() | Gets the RangeAreas object, comprising one or more rectangular ranges, that represents the print area for the worksheet. |
|
getPrintAreaOrNullObject() | Gets the RangeAreas object, comprising one or more rectangular ranges, that represents the print area for the worksheet. |
|
getPrintTitleColumns() | Gets the range object representing the title columns. | |
getPrintTitleColumnsOrNullObject() | Gets the range object representing the title columns. | |
getPrintTitleRows() | Gets the range object representing the title rows. | |
getPrintTitleRowsOrNullObject() | Gets the range object representing the title rows. | |
headerMargin | The worksheet's header margin, in points, for use when printing. | |
headersFooters | Header and footer configuration for the worksheet. | |
leftMargin | The worksheet's left margin, in points, for use when printing. | |
orientation | The worksheet's orientation of the page. | |
paperSize | The worksheet's paper size of the page. | |
printComments | Specifies if the worksheet's comments should be displayed when printing. | |
printErrors | The worksheet's print errors option. | |
printGridlines | Specifies if the worksheet's gridlines will be printed. | |
printHeadings | Specifies if the worksheet's headings will be printed. | |
printOrder | The worksheet's page print order option. | |
rightMargin | The worksheet's right margin, in points, for use when printing. | |
setPrintArea(printArea: Range | RangeAreas | string) | Sets the worksheet's print area. | |
setPrintMargins(unit: Excel.PrintMarginUnit, marginOptions: Excel.PageLayoutMarginOptions) | Sets the worksheet's page margins with units. | |
setPrintTitleColumns(printTitleColumns: Range | string) | Sets the columns that contain the cells to be repeated at the left of each page of the worksheet for printing. | |
setPrintTitleRows(printTitleRows: Range | string) | Sets the rows that contain the cells to be repeated at the top of each page of the worksheet for printing. | |
topMargin | The worksheet's top margin, in points, for use when printing. | |
zoom | The worksheet's print zoom options. | |
PageLayoutMarginOptions | bottom | Specifies the page layout bottom margin in the unit specified to use for printing. |
footer | Specifies the page layout footer margin in the unit specified to use for printing. | |
header | Specifies the page layout header margin in the unit specified to use for printing. | |
left | Specifies the page layout left margin in the unit specified to use for printing. | |
right | Specifies the page layout right margin in the unit specified to use for printing. | |
top | Specifies the page layout top margin in the unit specified to use for printing. | |
PageLayoutZoomOptions | horizontalFitToPages | Number of pages to fit horizontally. |
scale | Print page scale value can be between 10 and 400. | |
verticalFitToPages | Number of pages to fit vertically. | |
PivotField | sortByValues(sortBy: Excel.SortBy, valuesHierarchy: Excel.DataPivotHierarchy, pivotItemScope?: Array<PivotItem | string>) | Sorts the PivotField by specified values in a given scope. |
PivotLayout | autoFormat | Specifies if formatting will be automatically formatted when it's refreshed or when fields are moved. |
getDataHierarchy(cell: Range | string) | Gets the DataHierarchy that is used to calculate the value in a specified range within the PivotTable. | |
getPivotItems(axis: Excel.PivotAxis, cell: Range | string) | Gets the PivotItems from an axis that make up the value in a specified range within the PivotTable. | |
preserveFormatting | Specifies if formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items. | |
setAutoSortOnCell(cell: Range | string, sortBy: Excel.SortBy) | Sets the PivotTable to automatically sort using the specified cell to automatically select all necessary criteria and context. | |
PivotTable | enableDataValueEditing | Specifies if the PivotTable allows values in the data body to be edited by the user. |
useCustomSortLists | Specifies if the PivotTable uses custom lists when sorting. | |
Range | autoFill(destinationRange?: Range | string, autoFillType?: Excel.AutoFillType) | Fills a range from the current range to the destination range using the specified AutoFill logic. |
convertDataTypeToText() | Converts the range cells with data types into text. | |
convertToLinkedDataType(serviceID: number, languageCulture: string) | Converts the range cells into linked data types in the worksheet. | |
copyFrom(sourceRange: Range | RangeAreas | string, copyType?: Excel.RangeCopyType, skipBlanks?: boolean, transpose?: boolean) | Copies cell data or formatting from the source range or RangeAreas to the current range. |
|
find(text: string, criteria: Excel.SearchCriteria) | Finds the given string based on the criteria specified. | |
findOrNullObject(text: string, criteria: Excel.SearchCriteria) | Finds the given string based on the criteria specified. | |
flashFill() | Does a Flash Fill to the current range. | |
getCellProperties(cellPropertiesLoadOptions: CellPropertiesLoadOptions) | Returns a 2D array, encapsulating the data for each cell's font, fill, borders, alignment, and other properties. | |
getColumnProperties(columnPropertiesLoadOptions: ColumnPropertiesLoadOptions) | Returns a single-dimensional array, encapsulating the data for each column's font, fill, borders, alignment, and other properties. | |
getRowProperties(rowPropertiesLoadOptions: RowPropertiesLoadOptions) | Returns a single-dimensional array, encapsulating the data for each row's font, fill, borders, alignment, and other properties. | |
getSpecialCells(cellType: Excel.SpecialCellType, cellValueType?: Excel.SpecialCellValueType) | Gets the RangeAreas object, comprising one or more rectangular ranges, that represents all the cells that match the specified type and value. |
|
getSpecialCellsOrNullObject(cellType: Excel.SpecialCellType, cellValueType?: Excel.SpecialCellValueType) | Gets the RangeAreas object, comprising one or more ranges, that represents all the cells that match the specified type and value. |
|
getTables(fullyContained?: boolean) | Gets a scoped collection of tables that overlap with the range. | |
linkedDataTypeState | Represents the data type state of each cell. | |
removeDuplicates(columns: number[], includesHeader: boolean) | Removes duplicate values from the range specified by the columns. | |
replaceAll(text: string, replacement: string, criteria: Excel.ReplaceCriteria) | Finds and replaces the given string based on the criteria specified within the current range. | |
setCellProperties(cellPropertiesData: SettableCellProperties[][]) | Updates the range based on a 2D array of cell properties, encapsulating things like font, fill, borders, and alignment. | |
setColumnProperties(columnPropertiesData: SettableColumnProperties[]) | Updates the range based on a single-dimensional array of column properties, encapsulating things like font, fill, borders, and alignment. | |
setDirty() | Set a range to be recalculated when the next recalculation occurs. | |
setRowProperties(rowPropertiesData: SettableRowProperties[]) | Updates the range based on a single-dimensional array of row properties, encapsulating things like font, fill, borders, and alignment. | |
RangeAreas | address | Returns the RangeAreas reference in A1-style. |
addressLocal | Returns the RangeAreas reference in the user locale. |
|
areaCount | Returns the number of rectangular ranges that comprise this RangeAreas object. |
|
areas | Returns a collection of rectangular ranges that comprise this RangeAreas object. |
|
calculate() | Calculates all cells in the RangeAreas . |
|
cellCount | Returns the number of cells in the RangeAreas object, summing up the cell counts of all of the individual rectangular ranges. |
|
clear(applyTo?: Excel.ClearApplyTo) | Clears values, format, fill, border, and other properties on each of the areas that comprise this RangeAreas object. |
|
conditionalFormats | Returns a collection of conditional formats that intersect with any cells in this RangeAreas object. |
|
convertDataTypeToText() | Converts all cells in the RangeAreas with data types into text. |
|
convertToLinkedDataType(serviceID: number, languageCulture: string) | Converts all cells in the RangeAreas into linked data types. |
|
copyFrom(sourceRange: Range | RangeAreas | string, copyType?: Excel.RangeCopyType, skipBlanks?: boolean, transpose?: boolean) | Copies cell data or formatting from the source range or RangeAreas to the current RangeAreas . |
|
dataValidation | Returns a data validation object for all ranges in the RangeAreas . |
|
format | Returns a RangeFormat object, encapsulating the font, fill, borders, alignment, and other properties for all ranges in the RangeAreas object. |
|
getEntireColumn() | Returns a RangeAreas object that represents the entire columns of the RangeAreas (for example, if the current RangeAreas represents cells "B4:E11, H2", it returns a RangeAreas that represents columns "B:E, H:H"). |
|
getEntireRow() | Returns a RangeAreas object that represents the entire rows of the RangeAreas (for example, if the current RangeAreas represents cells "B4:E11", it returns a RangeAreas that represents rows "4:11"). |
|
getIntersection(anotherRange: Range | RangeAreas | string) | Returns the RangeAreas object that represents the intersection of the given ranges or RangeAreas . |
|
getIntersectionOrNullObject(anotherRange: Range | RangeAreas | string) | Returns the RangeAreas object that represents the intersection of the given ranges or RangeAreas . |
|
getOffsetRangeAreas(rowOffset: number, columnOffset: number) | Returns a RangeAreas object that is shifted by the specific row and column offset. |
|
getSpecialCells(cellType: Excel.SpecialCellType, cellValueType?: Excel.SpecialCellValueType) | Returns a RangeAreas object that represents all the cells that match the specified type and value. |
|
getSpecialCellsOrNullObject(cellType: Excel.SpecialCellType, cellValueType?: Excel.SpecialCellValueType) | Returns a RangeAreas object that represents all the cells that match the specified type and value. |
|
getTables(fullyContained?: boolean) | Returns a scoped collection of tables that overlap with any range in this RangeAreas object. |
|
getUsedRangeAreas(valuesOnly?: boolean) | Returns the used RangeAreas that comprises all the used areas of individual rectangular ranges in the RangeAreas object. |
|
getUsedRangeAreasOrNullObject(valuesOnly?: boolean) | Returns the used RangeAreas that comprises all the used areas of individual rectangular ranges in the RangeAreas object. |
|
isEntireColumn | Specifies if all the ranges on this RangeAreas object represent entire columns (e.g., "A:C, Q:Z"). |
|
isEntireRow | Specifies if all the ranges on this RangeAreas object represent entire rows (e.g., "1:3, 5:7"). |
|
setDirty() | Sets the RangeAreas to be recalculated when the next recalculation occurs. |
|
style | Represents the style for all ranges in this RangeAreas object. |
|
worksheet | Returns the worksheet for the current RangeAreas . |
|
RangeBorder | tintAndShade | Specifies a double that lightens or darkens a color for the range border, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. |
RangeBorderCollection | tintAndShade | Specifies a double that lightens or darkens a color for range borders. |
RangeCollection | getCount() | Returns the number of ranges in the RangeCollection . |
getItemAt(index: number) | Returns the range object based on its position in the RangeCollection . |
|
items | Gets the loaded child items in this collection. | |
RangeFill | pattern | The pattern of a range. |
patternColor | The HTML color code representing the color of the range pattern, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange"). | |
patternTintAndShade | Specifies a double that lightens or darkens a pattern color for the range fill. | |
tintAndShade | Specifies a double that lightens or darkens a color for the range fill. | |
RangeFont | strikethrough | Specifies the strikethrough status of font. |
subscript | Specifies the subscript status of font. | |
superscript | Specifies the superscript status of font. | |
tintAndShade | Specifies a double that lightens or darkens a color for the range font. | |
RangeFormat | autoIndent | Specifies if text is automatically indented when text alignment is set to equal distribution. |
indentLevel | An integer from 0 to 250 that indicates the indent level. | |
readingOrder | The reading order for the range. | |
shrinkToFit | Specifies if text automatically shrinks to fit in the available column width. | |
RemoveDuplicatesResult | removed | Number of duplicated rows removed by the operation. |
uniqueRemaining | Number of remaining unique rows present in the resulting range. | |
ReplaceCriteria | completeMatch | Specifies if the match needs to be complete or partial. |
matchCase | Specifies if the match is case-sensitive. | |
RowProperties | address | Represents the address property. |
addressLocal | Represents the addressLocal property. |
|
rowIndex | Represents the rowIndex property. |
|
SearchCriteria | completeMatch | Specifies if the match needs to be complete or partial. |
matchCase | Specifies if the match is case-sensitive. | |
searchDirection | Specifies the search direction. | |
SettableCellProperties | format | Represents the format property. |
hyperlink | Represents the hyperlink property. |
|
style | Represents the style property. |
|
SettableColumnProperties | columnHidden | Represents the columnHidden property. |
format | Represents the format property. |
|
SettableRowProperties | format | Represents the format property. |
rowHidden | Represents the rowHidden property. |
|
Shape | altTextDescription | Specifies the alternative description text for a Shape object. |
altTextTitle | Specifies the alternative title text for a Shape object. |
|
connectionSiteCount | Returns the number of connection sites on this shape. | |
delete() | Removes the shape from the worksheet. | |
fill | Returns the fill formatting of this shape. | |
geometricShape | Returns the geometric shape associated with the shape. | |
geometricShapeType | Specifies the geometric shape type of this geometric shape. | |
getAsImage(format: Excel.PictureFormat) | Converts the shape to an image and returns the image as a Base64-encoded string. | |
group | Returns the shape group associated with the shape. | |
height | Specifies the height, in points, of the shape. | |
id | Specifies the shape identifier. | |
image | Returns the image associated with the shape. | |
incrementLeft(increment: number) | Moves the shape horizontally by the specified number of points. | |
incrementRotation(increment: number) | Rotates the shape clockwise around the z-axis by the specified number of degrees. | |
incrementTop(increment: number) | Moves the shape vertically by the specified number of points. | |
left | The distance, in points, from the left side of the shape to the left side of the worksheet. | |
level | Specifies the level of the specified shape. | |
line | Returns the line associated with the shape. | |
lineFormat | Returns the line formatting of this shape. | |
lockAspectRatio | Specifies if the aspect ratio of this shape is locked. | |
name | Specifies the name of the shape. | |
onActivated | Occurs when the shape is activated. | |
onDeactivated | Occurs when the shape is deactivated. | |
parentGroup | Specifies the parent group of this shape. | |
rotation | Specifies the rotation, in degrees, of the shape. | |
scaleHeight(scaleFactor: number, scaleType: Excel.ShapeScaleType, scaleFrom?: Excel.ShapeScaleFrom) | Scales the height of the shape by a specified factor. | |
scaleWidth(scaleFactor: number, scaleType: Excel.ShapeScaleType, scaleFrom?: Excel.ShapeScaleFrom) | Scales the width of the shape by a specified factor. | |
setZOrder(position: Excel.ShapeZOrder) | Moves the specified shape up or down the collection's z-order, which shifts it in front of or behind other shapes. | |
textFrame | Returns the text frame object of this shape. | |
top | The distance, in points, from the top edge of the shape to the top edge of the worksheet. | |
type | Returns the type of this shape. | |
visible | Specifies if the shape is visible. | |
width | Specifies the width, in points, of the shape. | |
zOrderPosition | Returns the position of the specified shape in the z-order, with 0 representing the bottom of the order stack. | |
ShapeActivatedEventArgs | shapeId | Gets the ID of the activated shape. |
type | Gets the type of the event. | |
worksheetId | Gets the ID of the worksheet in which the shape is activated. | |
ShapeCollection | addGeometricShape(geometricShapeType: Excel.GeometricShapeType) | Adds a geometric shape to the worksheet. |
addGroup(values: Array<string | Shape>) | Groups a subset of shapes in this collection's worksheet. | |
addImage(base64ImageString: string) | Creates an image from a Base64-encoded string and adds it to the worksheet. | |
addLine(startLeft: number, startTop: number, endLeft: number, endTop: number, connectorType?: Excel.ConnectorType) | Adds a line to worksheet. | |
addTextBox(text?: string) | Adds a text box to the worksheet with the provided text as the content. | |
getCount() | Returns the number of shapes in the worksheet. | |
getItem(key: string) | Gets a shape using its name or ID. | |
getItemAt(index: number) | Gets a shape using its position in the collection. | |
items | Gets the loaded child items in this collection. | |
ShapeDeactivatedEventArgs | shapeId | Gets the ID of the shape deactivated shape. |
type | Gets the type of the event. | |
worksheetId | Gets the ID of the worksheet in which the shape is deactivated. | |
ShapeFill | clear() | Clears the fill formatting of this shape. |
foregroundColor | Represents the shape fill foreground color in HTML color format, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange") | |
setSolidColor(color: string) | Sets the fill formatting of the shape to a uniform color. | |
transparency | Specifies the transparency percentage of the fill as a value from 0.0 (opaque) through 1.0 (clear). | |
type | Returns the fill type of the shape. | |
ShapeFont | bold | Represents the bold status of font. |
color | HTML color code representation of the text color (e.g., "#FF0000" represents red). | |
italic | Represents the italic status of font. | |
name | Represents font name (e.g., "Calibri"). | |
size | Represents font size in points (e.g., 11). | |
underline | Type of underline applied to the font. | |
ShapeGroup | id | Specifies the shape identifier. |
shape | Returns the Shape object associated with the group. |
|
shapes | Returns the collection of Shape objects. |
|
ungroup() | Ungroups any grouped shapes in the specified shape group. | |
ShapeLineFormat | color | Represents the line color in HTML color format, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). |
dashStyle | Represents the line style of the shape. | |
style | Represents the line style of the shape. | |
transparency | Represents the degree of transparency of the specified line as a value from 0.0 (opaque) through 1.0 (clear). | |
visible | Specifies if the line formatting of a shape element is visible. | |
weight | Represents the weight of the line, in points. | |
SortField | subField | Specifies the subfield that is the target property name of a rich value to sort on. |
StyleCollection | getCount() | Gets the number of styles in the collection. |
getItemAt(index: number) | Gets a style based on its position in the collection. | |
Table | autoFilter | Represents the AutoFilter object of the table. |
TableAddedEventArgs | source | Gets the source of the event. |
tableId | Gets the ID of the table that is added. | |
type | Gets the type of the event. | |
worksheetId | Gets the ID of the worksheet in which the table is added. | |
TableChangedEventArgs | details | Gets the information about the change detail. |
TableCollection | onAdded | Occurs when a new table is added in a workbook. |
onDeleted | Occurs when the specified table is deleted in a workbook. | |
TableDeletedEventArgs | source | Gets the source of the event. |
tableId | Gets the ID of the table that is deleted. | |
tableName | Gets the name of the table that is deleted. | |
type | Gets the type of the event. | |
worksheetId | Gets the ID of the worksheet in which the table is deleted. | |
TableScopedCollection | getCount() | Gets the number of tables in the collection. |
getFirst() | Gets the first table in the collection. | |
getItem(key: string) | Gets a table by name or ID. | |
items | Gets the loaded child items in this collection. | |
TextFrame | autoSizeSetting | The automatic sizing settings for the text frame. |
bottomMargin | Represents the bottom margin, in points, of the text frame. | |
deleteText() | Deletes all the text in the text frame. | |
hasText | Specifies if the text frame contains text. | |
horizontalAlignment | Represents the horizontal alignment of the text frame. | |
horizontalOverflow | Represents the horizontal overflow behavior of the text frame. | |
leftMargin | Represents the left margin, in points, of the text frame. | |
orientation | Represents the angle to which the text is oriented for the text frame. | |
readingOrder | Represents the reading order of the text frame, either left-to-right or right-to-left. | |
rightMargin | Represents the right margin, in points, of the text frame. | |
textRange | Represents the text that is attached to a shape in the text frame, and properties and methods for manipulating the text. | |
topMargin | Represents the top margin, in points, of the text frame. | |
verticalAlignment | Represents the vertical alignment of the text frame. | |
verticalOverflow | Represents the vertical overflow behavior of the text frame. | |
TextRange | font | Returns a ShapeFont object that represents the font attributes for the text range. |
getSubstring(start: number, length?: number) | Returns a TextRange object for the substring in the given range. | |
text | Represents the plain text content of the text range. | |
Workbook | autoSave | Specifies if the workbook is in AutoSave mode. |
calculationEngineVersion | Returns a number about the version of Excel Calculation Engine. | |
chartDataPointTrack | True if all charts in the workbook are tracking the actual data points to which they are attached. | |
getActiveChart() | Gets the currently active chart in the workbook. | |
getActiveChartOrNullObject() | Gets the currently active chart in the workbook. | |
getIsActiveCollabSession() | Returns true if the workbook is being edited by multiple users (through co-authoring). |
|
getSelectedRanges() | Gets the currently selected one or more ranges from the workbook. | |
isDirty | Specifies if changes have been made since the workbook was last saved. | |
onAutoSaveSettingChanged | Occurs when the AutoSave setting is changed on the workbook. | |
previouslySaved | Specifies if the workbook has ever been saved locally or online. | |
usePrecisionAsDisplayed | True if calculations in this workbook will be done using only the precision of the numbers as they're displayed. | |
WorkbookAutoSaveSettingChangedEventArgs | type | Gets the type of the event. |
Worksheet | autoFilter | Represents the AutoFilter object of the worksheet. |
enableCalculation | Determines if Excel should recalculate the worksheet when necessary. | |
findAll(text: string, criteria: Excel.WorksheetSearchCriteria) | Finds all occurrences of the given string based on the criteria specified and returns them as a RangeAreas object, comprising one or more rectangular ranges. |
|
findAllOrNullObject(text: string, criteria: Excel.WorksheetSearchCriteria) | Finds all occurrences of the given string based on the criteria specified and returns them as a RangeAreas object, comprising one or more rectangular ranges. |
|
getRanges(address?: string) | Gets the RangeAreas object, representing one or more blocks of rectangular ranges, specified by the address or name. |
|
horizontalPageBreaks | Gets the horizontal page break collection for the worksheet. | |
onFormatChanged | Occurs when format changed on a specific worksheet. | |
pageLayout | Gets the PageLayout object of the worksheet. |
|
replaceAll(text: string, replacement: string, criteria: Excel.ReplaceCriteria) | Finds and replaces the given string based on the criteria specified within the current worksheet. | |
shapes | Returns the collection of all the Shape objects on the worksheet. | |
verticalPageBreaks | Gets the vertical page break collection for the worksheet. | |
WorksheetChangedEventArgs | details | Represents the information about the change detail. |
WorksheetCollection | onChanged | Occurs when any worksheet in the workbook is changed. |
onFormatChanged | Occurs when any worksheet in the workbook has a format changed. | |
onSelectionChanged | Occurs when the selection changes on any worksheet. | |
WorksheetFormatChangedEventArgs | address | Gets the range address that represents the changed area of a specific worksheet. |
getRange(ctx: Excel.RequestContext) | Gets the range that represents the changed area of a specific worksheet. | |
getRangeOrNullObject(ctx: Excel.RequestContext) | Gets the range that represents the changed area of a specific worksheet. | |
source | Gets the source of the event. | |
type | Gets the type of the event. | |
worksheetId | Gets the ID of the worksheet in which the data changed. | |
WorksheetSearchCriteria | completeMatch | Specifies if the match needs to be complete or partial. |
matchCase | Specifies if the match is case-sensitive. |
See also
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins