PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
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 the Spreadsheet control to be used.
<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.
Business / UI classification: UI Code
Component: wd270obj.dll
See also
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment