AddDefName |
Adds a new name to a range of cells. |
AddSheet |
Creates a new worksheet. The new worksheet becomes the active sheet. |
attachEvent |
Subscribes to the specified event and calls the callback function when the event fires. |
CreateBlipFill |
Creates a blip fill to apply to the object using the selected image as the object background. |
CreateBullet |
Creates a bullet for a paragraph with the character or symbol specified with the sSymbol parameter. |
CreateColorByName |
Creates a color selecting it from one of the available color presets. |
CreateColorFromRGB |
Creates an RGB color setting the appropriate values for the red, green and blue color components. |
CreateGradientStop |
Creates a gradient stop used for different types of gradients. |
CreateLinearGradientFill |
Creates a linear gradient fill to apply to the object using the selected linear gradient as the object background. |
CreateNewHistoryPoint |
Creates a new history point. |
CreateNoFill |
Creates no fill and removes the fill from the element. |
CreateNumbering |
Creates a bullet for a paragraph with the numbering character or symbol specified with the sType parameter. |
CreateParagraph |
Creates a new paragraph. |
CreatePatternFill |
Creates a pattern fill to apply to the object using the selected pattern as the object background. |
CreatePresetColor |
Creates a color selecting it from one of the available color presets. |
CreateRadialGradientFill |
Creates a radial gradient fill to apply to the object using the selected radial gradient as the object background. |
CreateRGBColor |
Creates an RGB color setting the appropriate values for the red, green and blue color components. |
CreateRun |
Creates a new smaller text block to be inserted to the current paragraph or table. |
CreateSchemeColor |
Creates a complex color scheme selecting from one of the available schemes. |
CreateSolidFill |
Creates a solid fill to apply to the object using a selected solid color as the object background. |
CreateStroke |
Creates a stroke adding shadows to the element. |
CreateTextPr |
Creates the empty text properties. |
detachEvent |
Unsubscribes from the specified event. |
Format |
Returns a class formatted according to the instructions contained in the format expression. |
GetActiveSheet |
Returns an object that represents the active sheet. |
GetComments |
Returns an array of ApiComment objects. |
GetDefName |
Returns the ApiName object by the range name. |
GetLocale |
Returns the current locale ID. |
GetMailMergeData |
Returns the mail merge data. |
GetRange |
Returns the ApiRange object by the range reference. |
GetRangeByNumber |
Returns an object that represents the range of the specified sheet using the maximum and minimum row/column coordinates. |
GetSelection |
Returns an object that represents the selected range. |
GetSheet |
Returns an object that represents a sheet. |
GetSheets |
Returns a sheet collection that represents all the sheets in the active workbook. |
GetThemesColors |
Returns a list of all the available theme colors for the spreadsheet. |
Intersect |
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. |
RecalculateAllFormulas |
Recalculates all formulas in the active workbook. |
ReplaceTextSmart |
Replaces each paragraph (or text in cell) in the select with the corresponding text from an array of strings. |
Save |
Saves changes to the specified document. |
SetLocale |
Sets a locale to the document. |
SetThemeColors |
Sets the theme colors to the current spreadsheet. |