Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items Next items

XLSheetMBS.LastRow as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns the zero-based index of the row after the last row in the sheet that contains a used cell.
Example:
dim book as XLBookMBS // your book instance

// get first sheet
dim sheet as XLSheetMBS = book.Sheet(0)

// show index of last row
dim LastRow as Integer = sheet.LastRow

MsgBox "LastRow: " + str(LastRow)

Feedback, Comments & Corrections

XLSheetMBS.MarginBottom as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The bottom margin of the sheet in inches.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.MarginLeft as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The left margin of the sheet in inches.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.MarginRight as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The right margin of the sheet in inches.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.MarginTop as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The top margin of the sheet in inches.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

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 Console & Web iOS
method XL MBS XL Plugin 14.3 Yes Yes Yes Yes No
Function: Gets the merged cells by index.

Feedback, Comments & Corrections

XLSheetMBS.MergeSize as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 14.3 Yes Yes Yes Yes No
Function: Returns a number of merged cells in this worksheet.

Feedback, Comments & Corrections

XLSheetMBS.Name as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The name of the sheet.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

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 Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Gets the named range coordianates by index.

See also:

Feedback, Comments & Corrections

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 Console & Web iOS
method XL MBS XL Plugin 14.0 Yes Yes Yes Yes No
Function: Gets the named range coordianates by index.
Notes:
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:

Feedback, Comments & Corrections

XLSheetMBS.NamedRangeCount as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns the number of named ranges in the sheet.

Feedback, Comments & Corrections

XLSheetMBS.Paper as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The paper size.
Notes:
See Paper* constants.
(Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.PictureCount as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns a number of pictures in this worksheet.

Feedback, Comments & Corrections

XLSheetMBS.PrintGridlines as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the gridlines are printed.
Notes:
True if gridlines are printed and false if aren't.
(Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.PrintRowCol as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the row and column headers are printed.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.PrintZoom as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Scaling factor for printing as a percentage.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.Protect as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether sheet is protected.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.ReadBlank(row as Integer, col as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Reads format from blank cell.
Notes:
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:

Feedback, Comments & Corrections

XLSheetMBS.ReadBlank(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Reads format from blank cell.
Notes:
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:

Feedback, Comments & Corrections

XLSheetMBS.ReadBoolean(row as Integer, col as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadComment(row as Integer, col as Integer) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

Feedback, Comments & Corrections

XLSheetMBS.ReadDate(row as Integer, col as Integer) as date
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 15.0 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 15.0 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadError(row as Integer, col as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

Feedback, Comments & Corrections

XLSheetMBS.ReadFormula(row as Integer, col as Integer) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadFormula(row as Integer, col as Integer, byref format as XLFormatMBS) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadNumber(row as Integer, col as Integer) as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

XLSheetMBS.ReadString(row as Integer, col as Integer) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
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.

See also:

Feedback, Comments & Corrections

Previous items Next items

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




Links
MBS Xojo Chart Plugins