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

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

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

XLSheetMBS.IsAutoFilter as boolean

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

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

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

Some examples using this method:

• /XL/Extract

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

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

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

See also:

• 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

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

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:

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

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

Returns false if specified cell isn't blank 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:

• ReadBlank(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean

XLSheetMBS.ReadBlank(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean

Returns false if specified cell isn't blank 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:

• ReadBlank(row as Integer, col as Integer) as boolean

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

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:

• ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean

Some examples using this method:

• /XL/Extract

XLSheetMBS.ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean

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:

• ReadBoolean(row as Integer, col as Integer) as boolean

XLSheetMBS.ReadComment(row as Integer, col as Integer) as string

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

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:

• ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date

XLSheetMBS.ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date

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:

• ReadDate(row as Integer, col as Integer) as date

XLSheetMBS.ReadDateTime(row as integer, col as integer) as dateTime

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:

• ReadDateTime(row as integer, col as integer, byref format as XLFormatMBS) as dateTime

XLSheetMBS.ReadDateTime(row as integer, col as integer, byref format as XLFormatMBS) as dateTime

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:

• ReadDateTime(row as integer, col as integer) as dateTime

XLSheetMBS.ReadError(row as Integer, col as Integer) as Integer

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

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:

• ReadFormula(row as Integer, col as Integer, byref format as XLFormatMBS) as string

Some examples using this method:

• /XL/Extract

XLSheetMBS.ReadFormula(row as Integer, col as Integer, byref format as XLFormatMBS) as string

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:

• ReadFormula(row as Integer, col as Integer) as string

XLSheetMBS.ReadNumber(row as Integer, col as Integer) as Double

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:

• ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double

Some examples using this method:

• /XL/Edit
• /XL/Extract

XLSheetMBS.ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double

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:

• ReadNumber(row as Integer, col as Integer) as Double

XLSheetMBS.ReadRichString(row as integer, col as integer) as XLRichStringMBS

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:

• ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS

XLSheetMBS.ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS

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:

• ReadRichString(row as integer, col as integer) as XLRichStringMBS

XLSheetMBS.ReadString(row as Integer, col as Integer) as string

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:

• ReadString(row as Integer, col as Integer, byref format as XLFormatMBS) as string

XLSheetMBS.ReadString(row as Integer, col as Integer, byref format as XLFormatMBS) as string

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:

• ReadString(row as Integer, col as Integer) as string

XLSheetMBS.ReadStyledText(row as integer, col as integer) as StyledText

We convert attributes like bold, italic, underline, color, font name and size.

See also:

• ReadStyledText(row as integer, col as integer, byref format as XLFormatMBS) as StyledText

XLSheetMBS.ReadStyledText(row as integer, col as integer, byref format as XLFormatMBS) as StyledText

We convert attributes like bold, italic, underline, color, font name and size.

See also:

• ReadStyledText(row as integer, col as integer) as StyledText

XLSheetMBS.ReadValue(row as integer, col as integer) as Variant

Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.

See also:

• ReadValue(row as integer, col as integer, byref format as XLFormatMBS) as Variant

XLSheetMBS.ReadValue(row as integer, col as integer, byref format as XLFormatMBS) as Variant

Depending on content we return number, boolean, text or date.
Returns nil for empty, error or blank cells.

See also:

• ReadValue(row as integer, col as integer) as Variant

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

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

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)

XLSheetMBS.RemoveDataValidations

XLSheetMBS.RemoveFilter

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

Returns false if an error occurs.

XLSheetMBS.RemovePictureByIndex(index as integer) as Boolean

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

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

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

XLSheetMBS.RemoveSelection

XLSheetMBS.RowColToAddr(row as Integer, col as Integer, rowRelative as boolean = true, colRelative as boolean = true) as string

// create new xls file
dim book as new XLBookMBS(false)

// create sheet
dim sheet as XLSheetMBS = book.AddSheet("Sheet1")

MsgBox sheet.RowColToAddr(5,5) // shows F6
MsgBox sheet.RowColToAddr(5,5,false,false) // shows $F$6

XLSheetMBS.RowHeight(row as Integer) as Double

XLSheetMBS.RowHeightPx(row as integer) as Integer

XLSheetMBS.RowHidden(row as Integer) as boolean

(Read and Write computed property)

XLSheetMBS.SelectionRange as string

XLSheetMBS.SetActiveCell(row as integer, col as integer)

XLSheetMBS.SetAutoFitArea(rowFirst as Integer = 0, colFirst as Integer = 0, rowLast as Integer = -1, colLast as Integer = -1)

The method setCol with -1 width value will affect only to the specified limited area.

XLSheetMBS.SetCol(colFirst as Integer, colLast as Integer, width as Double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean

If format is nil then format is ignored. Columns may be hidden. Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.

Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, ..., 9 as rendered in the normal style's font. Value -1 is used for autofit column widths. If format equals 0 then format is ignored. Columns may be hidden.

XLSheetMBS.SetColPx(colFirst as integer, colLast as integer, width as integer, format as XLFormatMBS = nil, hidden as boolean = false) as boolean

Value -1 is used for autofit column widths.
If format equals nil then format is ignored. Columns may be hidden.
Returns false if error occurs. Get an error info with the errorMessage function in XLBookMBS class.