ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
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
Adds or inserts a new worksheet into an Excel document. The added worksheet becomes the current worksheet.
Remark: This document must be handled by an xlsDocument variable and it must be opened in write mode.
New in version SaaS
Android This function is now available for Android applications.
Android Widget This function is now available in Android widget mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
Example
MyXLSDocument is xlsDocument
MyXLSDocument = xlsOpen("C:\Temp\Example.xls", xlsWrite)
IF xlsNbWorksheet(MyXLSDocument) = 1 THEN
	xlsAddWorksheet(MyXLSDocument, "MyWorksheet 2")
	xlsSave(MyXLSDocument)
END
Syntax
<Result> = xlsAddWorksheet(<XLS document> , <Worksheet name> [, <Worksheet position>])
<Result>: Boolean
  • True is the worksheet was added,
  • False if an error occurred. To get more details on the error, use ErrorInfo.
If the addition is performed, the added worksheet becomes the current worksheet.
<XLS document>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<Worksheet name>: Character string
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.
Component: wd300xls.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help