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

XL.Book.Clear

Removes all data from a workbook.

Component Version macOS Windows Linux Server iOS SDK
XL 16.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Book.Clear"; BookRef )   More

Parameters

Parameter Description Example
BookRef The reference number for the workbook. $ref

Result

Returns OK or error.

Description

Removes all data from a workbook.

Release notes

  • Version 16.1
    • Added XL.Book.Clear and XL.Book.ErrorCode functions.

Blog Entries

Created 20th January 2026, last changed 20th January 2026


XL.Book.BiffVersion - XL.Book.ConditionalFormat