PC SOFT

WINDEV的在线文档

版本: 20.0

类别: Spreadsheet functions
The following constants are used by the functions for managing the Spreadsheet controls:
The following functions are used to handle the Spreadsheet control:
Used to find out whether a cell is merged with other cells and to get the name of the merged cells.
Displays the specified cell in a Spreadsheet control:
  • either the visible area of the Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the top left corner of the visible area of the Spreadsheet control.
Saves the content of a Spreadsheet control in a file in XLSX format.
Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
Closes the XLXS document that was opened by 电子表格加载.
Deselects one or more cells in a Spreadsheet control.
Deletes all the data from a Spreadsheet control (cells, formulas, size and header layouts).
Deletes a worksheet from a Spreadsheet control.
Loads a file in XLSX format in a Spreadsheet control.
Selects one or more cells in a Spreadsheet control.
Allows the use of a WLanguage function/procedure in a formula of a Spreadsheet control.
Inserts a worksheet into a Spreadsheet control.
Inserts an empty column into a Spreadsheet control.
Inserts an empty row into a Spreadsheet control.
Seeks a value in the cells of a Spreadsheet control.
Adds a calculation formula into a Spreadsheet control.
Adds a worksheet into a Spreadsheet control.
Adds a data into a Spreadsheet control.
Retrieves the calculation formula of a cell found in a Spreadsheet control.
Retrieves the list of cells selected in a Spreadsheet control.
Selects a worksheet (identified by its name) in a Spreadsheet control.
Returns or modifies the style of the cells selected in a Spreadsheet control.
Modifies the border of the selected cells in a Spreadsheet control.
Returns or modifies the type and the mask of the cells selected in a Spreadsheet control.
Recalculates all the formulas found in a Spreadsheet control (including the formulas that use WLanguage functions/procedures).