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


Sets the template flag.

Component Version macOS Windows Linux Server iOS SDK
XL 7.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Book.SetTemplate"; bookRef )   More


Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref


Returns OK or error.


Sets the template flag.
Pass 1 for workbook is template, 0 for workbook is not template (default).
It allows to change type of file from a template file (xlt and xltx) to a regular file (xls and xlsx) and vice versa.

See also

This function checks for a license.

Created 22nd April 2017, last changed 22nd April 2017

XL.Book.SetRefR1C1 - XL.Book.SheetCount