Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.0   7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3    Statistic  

XL.Book.DeleteSheetsExcept

Deletes all sheets except the one with given name.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 5.4 Yes Yes Yes Yes Yes

MBS( "XL.Book.DeleteSheetsExcept"; bookRef; Name )

Parameters

Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
Name The name of the sheet to keep. "People"

Result

Returns OK or error.

Description

Deletes all sheets except the one with given name.
Returns error if sheet name is not found.
On success, the book has only one sheet left.
If the sheet to delete is referenced by other sheets, this may cause problems.

Examples

Delete all sheets except one:

Set Variable [$r; Value:MBS("XL.Book.DeleteSheetsExcept"; $bookRef; "Reiter 2")]

See also


XL.Book.DeleteSheet   -   XL.Book.FontCount

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins