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
xlsAddWorksheet (Function)
In French: xlsAjouteFeuille
Adds or inserts a new worksheet into an Excel document. The added worksheet becomes the current worksheet.
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.
Example
MyXLSDocument is xlsDocument
MyXLSDocument = xlsOpen("C:\Temp\Example.xls", xlsWrite)
IF xlsNbWorksheet(MyXLSDocument) = 1 THEN
xlsAddWorksheet(MyXLSDocument, "MyWorksheet 2")
END
Syntax
<Result> = xlsAddWorksheet(<XLS Document> , <Sheet Name> [, <Worksheet Position>])
<Result>: Boolean
  • True is the worksheet was added,
  • False if an error occurred. To find out the error details, use ErrorInfo.
If the addition is performed, the added worksheet becomes the current worksheet.
<XLS Document>: xlsDocument variable
Name of xlsDocument variable to use.
<Sheet Name>: Character string (with quotes)
Name of the worksheet that must be added or inserted. This name can contain between 1 and 31 characters. This name is not case sensitive.
<Worksheet Position>: Optional integer
Position of the worksheet that must be added (included between 1 and 255).
If this parameter is specified, the worksheet is inserted at the specified position.
If this parameter is specified, the worksheet is added after the existing worksheets.
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