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

XL.NewBook

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

Parameters

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.
0

Result

Returns book reference number.

Description

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.

Examples

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