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


Queries the text of a workbook.

Component Version macOS Windows Linux Server iOS SDK
XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Book.GetText"; bookRef { ; Flags } )   More


Parameter Description Example Flags
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
Flags Various flags.
Whether to return formulas as text.
If you pass 1 here, the formulas will be returned instead of their result.
Add 2 to return rich text cells as rich text instead of plain text.
0 Optional


Returns text of workbook.


Queries the text of a workbook.
Numbers are formatted as floating point numbers with dot as decimal separator.
Boolean values are returned as FALSE or TRUE.
This function will not calculate formulas.

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 12nd May 2023

XL.Book.GetRefR1C1 - XL.Book.InsertSheet