Api

Returns the Sheets collection that represents all the sheets in the active workbook.

Returns an object that represents the active sheet.

Returns an object that represents the selected range.

Returns an array of ApiComment objects.

Adds a new name to a range of cells.

Creates a new worksheet. The new worksheet becomes the active sheet.

Subscribes to the specified event and calls the callback function when the event fires.

Creates a blip fill to apply to the object using the selected image as the object background.

Creates a bullet for a paragraph with the character or symbol specified with the sSymbol parameter.

Creates a color selecting it from one of the available color presets.

Creates an RGB color setting the appropriate values for the red, green and blue color components.

Creates a gradient stop used for different types of gradients.

Creates a linear gradient fill to apply to the object using the selected linear gradient as the object background.

Creates a new history point.

Creates no fill and removes the fill from the element.

Creates a bullet for a paragraph with the numbering character or symbol specified with the sType parameter.

Creates a new paragraph.

Creates a pattern fill to apply to the object using the selected pattern as the object background.

Creates a color selecting it from one of the available color presets.

Creates a radial gradient fill to apply to the object using the selected radial gradient as the object background.

Creates an RGB color setting the appropriate values for the red, green and blue color components.

Creates a new smaller text block to be inserted to the current paragraph or table.

Creates a complex color scheme selecting from one of the available schemes.

Creates a solid fill to apply to the object using a selected solid color as the object background.

Creates a stroke adding shadows to the element.

Creates the empty text properties.

Unsubscribes from the specified event.

Returns a class formatted according to the instructions contained in the format expression.

Returns an object that represents the active sheet.

Returns an array of ApiComment objects.

Returns the ApiName object by the range name.

Returns the current locale ID.

Returns the mail merge data.

Returns the ApiRange object by the range reference.

Returns an object that represents the range of the specified sheet using the maximum and minimum row/column coordinates.

Returns an object that represents the selected range.

Returns an object that represents a sheet.

Returns a sheet collection that represents all the sheets in the active workbook.

Returns a list of all the available theme colors for the spreadsheet.

Returns the ApiRange object that represents the rectangular intersection of two or more ranges. If one or more ranges from a different worksheet are specified, an error will be returned.

Recalculates all formulas in the active workbook.

Replaces each paragraph (or text in cell) in the select with the corresponding text from an array of strings.

Saves changes to the specified document.

Sets a locale to the document.

Sets the theme colors to the current spreadsheet.

The callback function which is called when the specified range of the current sheet changes. Please note that the event is not called for the undo/redo operations.