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.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  

XL.NewBook

Creates a new workbook in memory.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 2.9 Yes Yes Yes Yes Yes

MBS( "XL.NewBook"; XML )

Parameters

Parameter Description Example value
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:

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

See also

Example Databases

Created 18th August 2014, last changed 5th March 2015


XL.LoadBookPartially   -   XL.Sheet.AddHyperlink

Feedback: Report problem or ask question.



Links
MBS FileMaker Plugins