Products Downloads


French version


 

I

ImageAdd

Adds an image to the workbook.

 

 

S

SelectionClear

Deletes the selected cells.

 

SelectionCompute

Evaluates the formulas in the selection.

 

SelectionCreateNamedSelection

Creates a named address referencing a selection of cells, that can be used in a formula.

 

SelectionGetAlphaValue

Gets the value of the selected cell in an ALPHA type variable.

 

SelectionGetAlphaValueArray

Gets the value of the cells of the selection in an array variable of the ALPHA type.

 

SelectionGetBooleanValue

Gets the value of the selected cell in a BOOL type variable.

 

SelectionGetBooleanValueArray

Gets the value of the cells of the selection in an array variable of the BOOL type.

 

SelectionGetComment

Gets the comment associated with the selected cell.

 

SelectionGetDateValue

Gets the value of the selected cell in a DATE type variable.

 

SelectionGetDateValueArray

Gets the value of the cells of the selection in an array variable of the DATE type.

 

SelectionGetFormula

Gets the formula of the selected cell.

 

SelectionGetNamedSelection

Gets the definition of a named address.

 

SelectionGetNumBin2Value

Gets the value of the selected cell in a NUM_BIN_2 type variable.

 

SelectionGetNumBin2ValueArray

Gets the value of the cells of the selection in an array variable of the NUM_BIN_2 type.

 

SelectionGetNumBin4Value

Gets the value of the selected cell in a NUM_BIN_4 type variable.

 

SelectionGetNumBin4ValueArray

Gets the value of the cells of the selection in an array variable of the NUM_BIN_4 type.

 

SelectionGetNumBin8Value

Gets the value of the selected cell in a NUM_BIN_8 type variable.

 

SelectionGetNumBin8ValueArray

Gets the value of the cells of the selection in an array variable of the NUM_BIN_8 type.

 

SelectionGetNumericValue

Gets the value of the selected cell in a NUM_E or NUM_P type variable.

 

SelectionGetNumericValueArray

Gets the value of the cells of the selection in an array variable of the NUM_E or NUM_P type.

 

SelectionGetTimeValue

Gets the value of the selected cell in a TIME type variable.

 

SelectionGetTimeValueArray

Gets the value of the cells of the selection in an array variable of the TIME type.

 

SelectionGetTimestampValue

Gets the value of the selected cell in a TIMESTAMP type variable.

 

SelectionGetTimestampValueArray

Gets the value of the cells of the selection in an array variable of the TIMESTAMP type.

 

SelectionMerge

Merges the cells of the selection.

 

SelectionRemoveComment

Deletes the comment from the selected cells.

 

SelectionRemoveFormula

Deletes the formula from the selected cells.

 

SelectionRemoveNamedSelection

Deletes a named address.

 

SelectionRemoveValue

Deletes the value of the selected cells.

 

SelectionSetAlphaValue

Defines the value of the cells in the selection from a value of the ALPHA type.

 

SelectionSetAlphaValueArray

Defines the value of the cells in the selection via an array of values of the ALPHA type.

 

SelectionSetBooleanValue

Defines the value of the cells in the selection from a boolean value.

 

SelectionSetBooleanValueArray

Defines the value of the cells in the selection via an array of boolean values.

 

SelectionSetComment

Defines the comment in the selected cells.

 

SelectionSetDateValue

Defines the value of the cells in the selection from a value of the DATE type.

 

SelectionSetDateValueArray

Defines the value of the cells in the selection via an array of values of the DATE type.

 

SelectionSetFormula

Defines the cells in the selection as formula type cells.

 

SelectionSetNumBin2Value

Defines the value of the cells in the selection via an array of values of the NUM_BIN_2 type.

 

SelectionSetNumBin2ValueArray

Defines the value of the cells in the selection via an array of values of the NUM_BIN_2 type.

 

SelectionSetNumBin4Value

Defines the value of the cells in the selection from a value of the NUM_BIN_4 type.

 

SelectionSetNumBin4ValueArray

Defines the value of the cells in the selection via an array of values of the NUM_BIN_4 type.

 

SelectionSetNumBin8Value

Defines the value of the cells in the selection from a value of the NUM_BIN_8 type.

 

SelectionSetNumBin8ValueArray

Defines the value of the cells in the selection via an array of values of the NUM_BIN_8 type.

 

SelectionSetNumericValue

Defines the value of the cells in the selection from a value of the NUM_E or NUM_P. type.

 

SelectionSetNumericValueArray

Defines the value of the cells in the selection via an array of decimal values.

 

SelectionSetTimeValue

Defines the value of the cells in the selection from a value of the TIME type.

 

SelectionSetTimeValueArray

Defines the value of the cells in the selection via an array of values of the TIME type.

 

SelectionSetTimestampValue

Defines the value of the cells in the selection from a value of the TIMESTAMP type.

 

SelectionSetTimestampValueArray

Defines the value of the cells in the selection via an array of values of the TIMESTAMP type.

 

SelectionSplit

Deletes merged ranges included in the selection.

 

SheetAdd

Creates a new spreadsheet.

 

SheetCompute

Evaluates all spreadsheet formulas.

 

SheetCount

Counts the number of workbook spreadsheets.

 

SheetGetActive

Gets the active worksheet.

 

SheetGetIndex

Gets the index of the worksheet specified in the workbook.

 

SheetGetName

Gets the name of the worksheet from its position in the workbook.

 

SheetProtect

Protects the sheet.

 

SheetRemove

Remove a spreadsheet.

 

SheetRemoveProtection

Removes protection of the sheet.

 

SheetRename

Renames a spreadsheet.

 

SheetSetActive

Defines the active worksheet.

 

SheetSetIndex

Changes the index of the spreadsheet in the workbook.

 

StyleAdjustColumnWidth

Adjust the width of a column to its contents.

 

StyleGetBackgroundColor

Gets the background color of the selected cell.

 

StyleGetBorder

Retrieves the border style of the selected cell.

 

StyleGetBorderColor

Gets the border color of the selected cells.

 

StyleGetColumnWidth

Gets the character width of the selected cell.

 

StyleGetFontFace

Gets the font name of the selected cell.

 

StyleGetFontSize

Gets the font size of the selected cell.

 

StyleGetFormat

Gets the format of the selected cell.

 

StyleGetHidden

Determines whether the formula associated with a selected cell is hidden.

 

StyleGetHorizontalAlignment

Gets the horizontal text alignment in the selected cell.

 

StyleGetIndent

Determines the indentation of text in the selected cell (in characters).

 

StyleGetLocked

Determines whether the processed cell is locked.

 

StyleGetRotation

Gets the text rotation of the selected cell.

 

StyleGetRowHeight

Gets the height of the first line of the selection.

 

StyleGetShrinkToFit

Determines whether shrinking the size of the text is allowed for the selected cell.

 

StyleGetTextColor

Gets the text color of the selected cell.

 

StyleGetTextProperties

Gets the display properties of the text in the selected cell.

 

StyleGetVerticalAlignment

Gets the vertical text alignment in the selected cell.

 

StyleGetWrapText

Determines whether the text of the selected cell can move to the next line.

 

StyleRemoveFormat

Deletes the format of the selected cells.

 

StyleSetBackgroundColor

Sets the background color of the selected cells.

 

StyleSetBorder

Sets the style of the borders of the selected cells.

 

StyleSetBorderColor

Sets the color of the borders of the selected cells.

 

StyleSetColumnWidth

Sets the column width in characters corresponding to the selected cells.

 

StyleSetFontFace

Sets the font name of the selected cells.

 

StyleSetFontSize

Sets the font size of the selected cells.

 

StyleSetFormat

Sets the format of the selected cells.

 

StyleSetHidden

Hides the formulas associated with the selected cells.

 

StyleSetHorizontalAlignment

Sets the horizontal text alignment of the selected cells.

 

StyleSetIndent

Sets the indentation of the text of the selected cells.

 

StyleSetLocked

Locks the selected cells.

 

StyleSetRotation

Sets the rotation of the text of the selected cells.

 

StyleSetRowHeight

Sets the height in points of the selected rows.

 

StyleSetShrinkToFit

Reducing the size of text in the selected cells.

 

StyleSetTextColor

Sets the text color of the selected cells.

 

StyleSetTextProperties

Sets the display properties of the text in the selected cells.

 

StyleSetVerticalAlignment

Sets the vertical text alignment of the selected cells.

 

StyleSetWrapText

Allows the text of the selected cells to be sent to the next line if the text width exceeds the width of the cell.

 

 

↑ Top of page

W

WorkbookClose

Closes the workbook and releases the related resources.

 

WorkbookCompute

Evaluates all workbook formulas.

 

WorkbookCreate

Creates a new workbook.

 

WorkbookGetData

Gets the workbook data from an IMAGE variable.

 

WorkbookGetFormat

Gets the workbook file format.

 

WorkbookLoad

Loads a workbook from an IMAGE variable containing the data.

 

WorkbookOpen

Opens an Excel file in .xls or .xlsx format.

 

WorkbookSave

Saves the workbook.

 

WorkbookSaveAs

Saves the workbook under a specified name.

 

 

 

↑ Top of page

  • Aucune étiquette