Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
Statistic
FMM
Blog
XL.NewBook
Creates a new workbook in memory.
Component | Version | macOS | Windows | Linux | Server | FileMaker 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
- XL.Book.AddCustomNumFormat
- XL.Book.AddFormat
- XL.Book.AddSheet
- XL.Book.Release
- XL.Color.Pack
- XL.CopyContent
- XL.Font.SetColor
- XL.Format.SetWrap
- XL.Sheet.CellWriteNumber
- XL.Sheet.SetCol
Example Databases
Blog Entries
Release notes
- Version 8.0
- Added better error message when calling XL.LoadBook or XL.NewBook without calling XL.Initialize.
Created 18th August 2014, last changed 17th March 2020
XL.LoadBookPartially - XL.Sheet.AddDataValidation
Feedback: Report problem or ask question.

Links
MBS FileMaker tutorial videos