PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment