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.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1    Statistic  


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 )   More


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"


Returns OK or error.


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.


Delete all sheets except one:

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

See also

Blog Entries

Created 4th November 2015, last changed 4th November 2015

XL.Book.DeleteSheet   -   XL.Book.FontCount

Feedback: Report problem or ask question.

MBS Xojo blog