PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
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
Inserts an empty row into a Spreadsheet control found in a window.
Example
// Inserts several rows
FOR I = 2 TO 5
PSHEET_Spreadsheet.InsertRow(I)
END
Syntax
<Spreadsheet control>.InsertLine([<Row>])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Row>: Optional integer
Number of the row before which the new row will be inserted. For example, if this parameter is set to 2, the new row will be inserted at position 2. The existing rows will be moved to the bottom and the formulas will be updated.
If this parameter is not specified and if a row is selected in the control, the insertion will be performed before the selected row. Otherwise (no selected row), the function has no effect.
Remarks
  • The insert operation is added into the list of operations to cancel: the user can undo this operation via the context menu or by pressing Ctrl + Z.
  • This function can only be used on a Spreadsheet control found in a window.
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,
- ...
Component: wd280obj.dll
See also
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment