Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLSheetMBS class.

XLSheetMBS.DelHyperlink(index as Integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Removes hyperlink by index.

Index: The index from 0 to HyperlinkSize.

XLSheetMBS.DelMerge(row as Integer, col as Integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Removes merged cells.

Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.

XLSheetMBS.DelMergeByIndex(index as Integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Removes merged cells by index.

Index: From 0 to MergeSize-1.

XLSheetMBS.DelNamedRange(name as string, scopeId as Integer = -2) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Deletes the named range by name.

Returns false if error occurs. Get error info with XLBookMBS.errorMessage().
scopeId - index of sheet for local named range or ScopeWorkbook for global named range.

XLSheetMBS.FormControl(index as integer) as XLFormControlMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns a form control with the specified index.

The index must be less than the return value of the FormControlCount property.
This allows you to batch pre-fill form fields in an Excel document.
You may need Excel to create the template with the form fields.

XLSheetMBS.Hyperlink(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the hyperlink and its coordianates by index.

Some examples using this method:

XLSheetMBS.HyperlinkIndex(row as integer, col as integer) as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 23.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Checks if the cell contains a hyperlink.

Returns an index of hyperlink if exists, -1 if there is no hyperlink in this cell.

XLSheetMBS.InsertCol(colFirst as Integer, colLast as Integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Inserts columns from colFirst to colLast.

Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.

XLSheetMBS.InsertColAndKeepRanges(colFirst as integer, colLast as integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 20.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Inserts columns from colFirst to colLast.

Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.

XLSheetMBS.InsertRow(rowFirst as Integer, rowLast as Integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Inserts rows from rowFirst to rowLast.

Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Updates existing named ranges.

XLSheetMBS.InsertRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 20.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Inserts rows from rowFirst to rowLast.

Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
Doesn't update existing named ranges.

XLSheetMBS.IsAutoFilter as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether this sheet has an auto filter.

Returns true if there is an auto filter, otherwise false.

XLSheetMBS.IsDate(row as Integer, col as Integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Checks that cell contains a date or time value.

XLSheetMBS.IsFormula(row as Integer, col as Integer) as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Checks that cell contains a formula.

Some examples using this method:

XLSheetMBS.IsRichString(row as integer, col as integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 20.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Checks that the cell contains a rich string with multiple fonts.

If return value is true read it with the readRichString() method.

XLSheetMBS.Merge(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the merged cells by index.

XLSheetMBS.NamedRange(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref ColFirst as Integer, byref ColLast as Integer) as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the named range coordianates by index.

See also:

XLSheetMBS.NamedRange(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref ColFirst as Integer, byref ColLast as Integer, byref scopeId as Integer, byref Hidden as Boolean) as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the named range coordianates by index.

scopeId - index of sheet for local named range or ScopeWorkbook for global named range.
hidden - true if named range is hidden and false if isn't.

See also:

XLSheetMBS.Table(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref ColFirst as Integer, byref ColLast as Integer, byref headerRowCount as Integer, byref totalsRowCount as Integer) as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the table parameters by index.

headerRowCount - the number of header rows showing at the top of the table. 0 means that the header row is not shown.
totalsRowCount - the number of totals rows that shall be shown at the bottom of the table. 0 means that the totals row is not shown.
Returns a string representing the name of the table.

See also:

XLSheetMBS.Table(name as string, byref rowFirst as integer, byref rowLast as integer, byref ColFirst as integer, byref ColLast as integer, byref headerRowCount as integer, byref totalsRowCount as integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 23.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the table parameters by name.

headerRowCount - the number of header rows showing at the top of the table. 0 means that the header row is not shown.
totalsRowCount - the number of totals rows that shall be shown at the bottom of the table. 0 means that the totals row is not shown.

Returns true if the table is found.

See also:

XLSheetMBS.TableByIndex(index as Integer) as XLTableMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 25.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets a table by the specified index.

Only for xlsx files.
Returns the table if successed, nil if failed.

XLSheetMBS.TableByName(Name as String) as XLTableMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 25.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets a table by the specified name.

Only for xlsx files.
Returns the table if successed, nil if failed.

The items on this page are in the following plugins: MBS XL Plugin.


The biggest plugin in space...