Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Creates a new workbook in memory.

Component Version macOS Windows Linux Server iOS SDK
XL 2.9 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.NewBook"; XML )   More


Parameter Description Example
XML Pass 1 to create a new XML bases Excel file (xlsx).
Else pass 0 for an old style file (xls). Default is 0.


Returns book reference number.


Creates a new workbook in memory.
Please call XL.Book.Release later to free memory.
Book reference numbers are starting at 19000 and counting up for each new book.


Create a new book in xls format (older):

$book = MBS( "XL.NewBook"; 0 )

Create a new book in xlsx format (newer):

$book = MBS( "XL.NewBook"; 1 )

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 24th May 2024

XL.LoadBookPartially - XL.Sheet.AddConditionalFormatting