Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLSheetMBS class.
XLSheetMBS.ReadBoolean(row as Integer, col as Integer) as boolean
Function:
Reads a boolean value and its format from cell.
Notes:
If nil format is returned then an error occured. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
If nil format is returned then an error occured. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
Some examples using this method:
XLSheetMBS.ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
Function:
Reads a boolean value and its format from cell.
Notes:
If nil format is returned then an error occured. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
If nil format is returned then an error occured. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadComment(row as Integer, col as Integer) as string
Function:
Reads a comment from specified cell.
Notes:
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
XLSheetMBS.ReadDate(row as Integer, col as Integer) as date
Function:
Reads a date/time and its format from cell.
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 15.0 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date
Function:
Reads a date/time and its format from cell.
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 15.0 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadDateTime(row as integer, col as integer) as dateTime
Function:
Reads a date/time and its format from cell.
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadDateTime(row as integer, col as integer, byref format as XLFormatMBS) as dateTime
Function:
Reads a date/time and its format from cell.
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Internally uses XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadError(row as Integer, col as Integer) as Integer
Function:
Reads error from cell.
Notes:
See ErrorType* constants.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
See ErrorType* constants.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
XLSheetMBS.ReadFormula(row as Integer, col as Integer) as string
Function:
Reads a formula string and its format from cell.
Notes:
Returns nil if specified cell doesn't contain formula or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns nil if specified cell doesn't contain formula or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
Some examples using this method:
XLSheetMBS.ReadFormula(row as Integer, col as Integer, byref format as XLFormatMBS) as string
Function:
Reads a formula string and its format from cell.
Notes:
Returns nil if specified cell doesn't contain formula or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns nil if specified cell doesn't contain formula or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadNumber(row as Integer, col as Integer) as Double
Function:
Reads a number or date/time and its format from cell.
Notes:
Use XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Use XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
Some examples using this method:
XLSheetMBS.ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double
Function:
Reads a number or date/time and its format from cell.
Notes:
Use XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Use XLBookMBS.dateUnpack() for extract date/time parts from double.
If format is returned as nil, then error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadRichString(row as integer, col as integer) as XLRichStringMBS
Function:
Reads a rich string with multiple fonts and its format from the cell.
Notes:
It's possible to check if the specified cell contains a rich string with the isRichString() method.
Returns nil if the specified cell doesn't contain a string or error occurs.
Get error info with XLBookMBS.ErrorMessage property.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
It's possible to check if the specified cell contains a rich string with the isRichString() method.
Returns nil if the specified cell doesn't contain a string or error occurs.
Get error info with XLBookMBS.ErrorMessage property.
See also:
XLSheetMBS.ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS
Function:
Reads a rich string with multiple fonts and its format from the cell.
Notes:
It's possible to check if the specified cell contains a rich string with the isRichString() method.
Returns nil if the specified cell doesn't contain a string or error occurs.
Get error info with XLBookMBS.ErrorMessage property.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
It's possible to check if the specified cell contains a rich string with the isRichString() method.
Returns nil if the specified cell doesn't contain a string or error occurs.
Get error info with XLBookMBS.ErrorMessage property.
See also:
XLSheetMBS.ReadString(row as Integer, col as Integer) as string
Function:
Reads a string and its format from cell.
Notes:
Returns "" if specified cell doesn't contain string or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns "" if specified cell doesn't contain string or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadString(row as Integer, col as Integer, byref format as XLFormatMBS) as string
Function:
Reads a string and its format from cell.
Notes:
Returns "" if specified cell doesn't contain string or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns "" if specified cell doesn't contain string or error occurs. Get error info with XLBookMBS.ErrorMessage property.
Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.
See also:
XLSheetMBS.ReadStyledText(row as integer, col as integer) as StyledText
Function:
Reads rich string of a cell and converts to StyledText.
Notes: We convert attributes like bold, italic, underline, color, font name and size.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Notes: We convert attributes like bold, italic, underline, color, font name and size.
See also:
XLSheetMBS.ReadStyledText(row as integer, col as integer, byref format as XLFormatMBS) as StyledText
Function:
Reads rich string from a cell and returns as StyledText.
Notes: We convert attributes like bold, italic, underline, color, font name and size.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Notes: We convert attributes like bold, italic, underline, color, font name and size.
See also:
XLSheetMBS.ReadValue(row as integer, col as integer) as Variant
Function:
Reads a value value from a cell.
Notes:
Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.
See also:
XLSheetMBS.ReadValue(row as integer, col as integer, byref format as XLFormatMBS) as Variant
Function:
Reads a value value from a cell.
Notes:
Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.
See also:
XLSheetMBS.RemoveCol(colFirst as Integer, colLast as Integer) as boolean
Function:
Removes columns from colFirst to colLast.
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.
XLSheetMBS.RemoveColAndKeepRanges(colFirst as integer, colLast as integer) as boolean
Function:
Removes columns from colFirst to colLast.
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.
XLSheetMBS.RemoveComment(row as Integer, col as Integer)
Function:
Removes a comment from the cell (only for xls format).
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLSheetMBS.RemoveDataValidations
Function:
Removes all data validations for the sheet (only for xlsx files).
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 17.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLSheetMBS.RemoveFilter
Function:
Removes the AutoFilter from the sheet.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLSheetMBS.RemovePicture(row as integer, col as integer) as Boolean
Function:
Removes a picture in the specified position.
Notes: Returns false if an error occurs.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Returns false if an error occurs.
XLSheetMBS.RemovePictureByIndex(index as integer) as Boolean
Function:
Removes a picture by specified index. Returns false if an error occurs.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLSheetMBS.RemoveRow(rowFirst as Integer, rowLast as Integer) as boolean
Function:
Removes rows from rowFirst to rowLast.
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.
XLSheetMBS.RemoveRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean
Function:
Removes rows from rowFirst to rowLast.
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.
XLSheetMBS.RemoveSelection
Function:
Removes all selection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | XL | MBS XL Plugin | 23.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
The items on this page are in the following plugins: MBS XL Plugin.
