|
|
|
|
|
|
|
|
|
|
<xlsDocument variable>.DeleteWorksheet (Function) In french: <Variable xlsDocument>.SupprimeFeuille Deletes a worksheet from the Excel document. Note: This document must be manipulated using a variable of type xlsDocument and be opened in write mode.
Syntax
<Result> = <XLS document>.DeleteWorksheet([<Worksheet position>])
<Result>: Boolean - True is the worksheet was deleted,
- False if an error occurs. To get more details on the error, use ErrorInfo.
<XLS document>: xlsDocument variable Name of the xlsDocument variable corresponding to the Excel file to use. <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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|