PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Deletes a column from a Spreadsheet control.
Example
// Deletes columns B and C from the current worksheet
SpreadsheetDeleteColumn(PSHEET_MySpreadsheet, 2)
SpreadsheetDeleteColumn(PSHEET_MySpreadsheet, "C")
Syntax
SpreadsheetDeleteColumn(<Spreadsheet control> , <Column> [, <Worksheet>])
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.
<Column>: Integer or character string
Column to delete. This parameter can correspond to:
  • the column number, for example: 1.
    The column numbers start from 1
  • the column name, "A" for example.
The function has no effect if this parameter is not valid.
<Worksheet>: Optional integer
Number of the worksheet to use. If this parameter is not specified, the current worksheet is used.
The function has no effect if this parameter is not valid.
Remarks
After the function execution:
  • the columns found on the right of the deleted column are shifted to the left.
  • the content of expressions is renamed.
Component : wd240obj.dll
See also
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment