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: 8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3    Statistic  


Deletes a sheet with specified index.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Book.DeleteSheet"; bookRef; sheetIndex )   More


Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet to delete. This number ranges from 0 to XL.Book.SheetCount-1. 0


Returns OK on success.


Deletes a sheet with specified index.
If the sheet to delete is referenced by other sheets, this may cause problems.


Remove all sheets but the second one:

#Find libXL and load it
If [MBS("XL.IsInitialized") ≠ 1]
    Perform Script [“InitXL”]
End If
#Load template excel file
Set Variable [$bookRef; Value:MBS( "XL.LoadBook"; "/Users/cs/Desktop/Test.xlsx")]
If [MBS("IsError")]
    Show Custom Dialog ["Error"; $bookRef]
    Exit Script []
End If
#remove all but second sheet
Set Variable [$c; Value:MBS( "XL.Book.SheetCount"; $bookRef )]
If [$c >= 2]
    If [$c > 2]
        Set Variable [$i; Value:2]
            Set Variable [$r; Value:MBS( "XL.Book.DeleteSheet"; $bookRef; $i )]
            Set Variable [$i; Value:$i + 1]
            Exit Loop If [$c = $i]
        End Loop
    End If
    Set Variable [$r; Value:MBS( "XL.Book.DeleteSheet"; $bookRef; 0 )]
End If
#Save to container and cleanup
Set Variable [$r; Value:MBS("XL.Book.SaveToFile"; $bookRef; "/Users/cs/Desktop/output.xlsx")]
Set Variable [$r; Value:MBS( "XL.Book.Release"; $bookRef)]

See also

Created 18th August 2014, last changed 19th April 2016

XL.Book.CustomNumFormat   -   XL.Book.DeleteSheetsExcept

Feedback: Report problem or ask question.

MBS Xojo Chart Plugins