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
xlsDeleteWorksheet (Function)
In French: xlsSupprimeFeuille
Deletes a worksheet from the Excel document.
Note: This document must be handled by an xlsDocument variable and it must be opened in write mode.
Versions 16 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 16
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
Syntax
<Result> = xlsDeleteWorksheet(<XLS Document> [, <Worksheet Position>])
<Result>: Boolean
  • True is the worksheet was deleted,
  • False if an error occurred. To find out the error details, use ErrorInfo.
<XLS Document>: xlsDocument variable
Name of xlsDocument variable corresponding to the Excel file to handle.
<Worksheet Position>: Optional integer
Position of the worksheet to delete (included between 1 and 255).
If this parameter is specified, the specified worksheet is deleted.
If this parameter is not specified, the current worksheet is deleted.
Remarks
  • To be able to delete a worksheet from an Excel document, there must be at least another worksheet left in the Excel document.
  • If the current worksheet is deleted, the new current worksheet corresponds to the next worksheet or the last worksheet.
  • If the deleted worksheet is found before the current worksheet, the subscript of the current worksheet is decremented by 1 in order to stay on the same worksheet.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230xls.dll
Linux wd230xls.so
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment