ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Spreadsheet functions (prefix syntax)
The following functions are used to manipulate Spreadsheet controls (prefix syntax):
<Spreadsheet>.AddDataAdds a data into a Spreadsheet control found in a window.
<Spreadsheet>.AddFormulaAdds a calculation formula into a Spreadsheet control found in a window.
<Spreadsheet>.AddImageAdds an image into the current worksheet of a Spreadsheet control.
New in version 2024
<Spreadsheet>.AddLink
Creates a link in a Spreadsheet control cell. The text in the cell becomes the link.
<Spreadsheet>.AddNameSpecifies a name to identify a cell found in a Spreadsheet control.
<Spreadsheet>.AddWorksheetAdds a worksheet into a Spreadsheet control found in a window.
<Spreadsheet>.AllowProcedureAllows the use of a WLanguage function/procedure in a formula of a Spreadsheet control.
<Spreadsheet>.BorderSelectionModifies the border of selected cells in a Spreadsheet control found in a window.
<Spreadsheet>.CloseCloses the XLSX document that was opened by <Spreadsheet>.Load.
<Spreadsheet>.ControlFormulaAllows you to use a control in order to create a custom formula bar for the Spreadsheet control.
<Spreadsheet>.DeleteAllDeletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts).
<Spreadsheet>.DeleteColumnDeletes a column from a Spreadsheet control.
<Spreadsheet>.DeleteRowDeletes a row from a Spreadsheet control.
<Spreadsheet>.DeleteWorksheetDeletes a worksheet from a Spreadsheet control found in a window.
<Spreadsheet>.EndModificationSignals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo").
<Spreadsheet>.FreezeUsed to freeze the display of a row or column in a Spreadsheet control.
<Spreadsheet>.GetFormulaRetrieves the calculation formula of a cell found in a Spreadsheet control of a window.
<Spreadsheet>.GetMergeUsed to find out whether a cell is merged with other cells and to get the name of merged cells.
<Spreadsheet>.GetSelectionRetrieves the list of selected cells in a Spreadsheet control found in a window.
<Spreadsheet>.InsertColumnInserts an empty column into a Spreadsheet control found in a window.
<Spreadsheet>.InsertRowInserts an empty row into a Spreadsheet control found in a window.
<Spreadsheet>.InsertWorksheetInserts a worksheet into a Spreadsheet control found in a window.
<Spreadsheet>.LoadLoads a file in XLSX format in a Spreadsheet control found in a window.
<Spreadsheet>.MergeCellMerges specified or selected cells in a Spreadsheet control.
<Spreadsheet>.MoveWorksheetMoves a worksheet within a Spreadsheet control in a window.
<Spreadsheet>.PositionDisplays the specified cell in a Spreadsheet control found in a window:
  • either the visible area of Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the upper-left corner of visible area of Spreadsheet control.
<Spreadsheet>.RecalculateAllRecalculates all formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures).
<Spreadsheet>.ReplaceFinds and replaces a value in a Spreadsheet control.
<Spreadsheet>.RestorePositionAndSelectionRestores:
  • the scrollbar position in a Spreadsheet control,
  • the current worksheet,
  • the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by <Spreadsheet>.SavePositionAndSelection.
<Spreadsheet>.SaveSaves the content of a Spreadsheet control in a file in XLSX format.
<Spreadsheet>.SavePositionAndSelectionSaves:
  • the scrollbar position in a Spreadsheet control for the current worksheet,
  • the current worksheet in the Spreadsheet control,
  • the selected elements in the Spreadsheet control for the current worksheet.
<Spreadsheet>.SeekSeeks a value in the cells of a Spreadsheet control found in a window.
<Spreadsheet>.SelectMinusDeselects one or more cells in a Spreadsheet control found in a window.
<Spreadsheet>.SelectPlusSelects one or more cells in a Spreadsheet control found in a window.
<Spreadsheet>.SelectWorksheetSelects a worksheet (identified by its name) in a Spreadsheet control.
<Spreadsheet>.SortSelectionSorts the values selected in a Spreadsheet control.
<Spreadsheet>.StartModificationIndicates the start of a series of actions performed in a Spreadsheet control in a single event ("undo/redo").
<Spreadsheet>.StyleSelectionReturns or modifies the style of selected cells in a Spreadsheet control found in a window.
<Spreadsheet>.TypeAndMaskSelectionReturns or modifies the type and mask of selected cells in a Spreadsheet control.
<Spreadsheet>.UnmergeCellUnmerges the specified or selected cell in a Spreadsheet control.
Related Examples:
The Spreadsheet control Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control.
This example explains how to:
- load an xlsx file in a spreadsheet control,
- save the spreadsheet in a file,
- fill the control with data coming from the database,
- insert rows, columns,
- access the cells and handle them (modify their value, their style, ...),
- enter formulas,
- ...
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/01/2024

Send a report | Local help