Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

XLSheetMBS.SplitInfo(byref row as Integer, byref col 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 split information (position of frozen pane) in the sheet.
Notes:
row: vertical position of the split;
col: horizontal position of the split.
Returns true on success.

Feedback, Comments & Corrections

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 Console & Web iOS
method XL MBS XL Plugin 16.5 Yes Yes Yes Yes No
Function: Gets the table parameters by index.
Notes:
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.

Feedback, Comments & Corrections

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

Feedback, Comments & Corrections

XLSheetMBS.VCenter 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 sheet is centered vertically when printed.
Notes: (Read and Write computed property)

Feedback, Comments & Corrections

XLSheetMBS.WriteBlank(row as Integer, col as Integer, format as XLFormatMBS = nil) 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: Writes blank cell with specified format.
Notes:
Returns false if 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.

Feedback, Comments & Corrections

XLSheetMBS.WriteBoolean(row as Integer, col as Integer, value as boolean, format as XLFormatMBS = nil) 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: Writes a bool value into cell with specified format.
Notes:
If format is nil then format is ignored.
Returns false if 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.

Feedback, Comments & Corrections

XLSheetMBS.WriteComment(row as Integer, col as Integer, value as string, author as string, width as Integer, height 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: Writes a comment to the cell.
Notes:
row and col: cell's position
value: comment string
author: author string
width: width of text box in pixels
height: height of text box in pixels

Col and Row are zero based.
Please remember that Excel files have limits like 65536 rows and 256 columns.

Feedback, Comments & Corrections

XLSheetMBS.WriteDate(row as Integer, col as Integer, value as date, format as XLFormatMBS = nil) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 15.0 Yes Yes Yes Yes No
Function: Writes a date/time into cell with specified format.
Notes:
If format is nil then format is ignored. Internally uses XLBookMBS.datePack() for packing date/time parts to double.
Returns false if 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.

Feedback, Comments & Corrections

XLSheetMBS.WriteError(row as Integer, col as Integer, Error as Integer, format as XLFormatMBS = nil)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 16.5 Yes Yes Yes Yes No
Function: Writes error into the cell with specified format.
Notes: If format equals nil then format is ignored.

Feedback, Comments & Corrections

XLSheetMBS.WriteFormula(row as Integer, col as Integer, value as string, format as XLFormatMBS = nil) 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: Writes a formula into cell with specified format.
Notes:
If format is nil then format is ignored. Returns false if 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.
As LibXL does not calculate the result of the formula, it will not encode the result in the Excel file. It does only store the formula, so an app opening the file will have to do the calculation. But QuickLook on Mac OS X does not calculate, so results do not show there.
Examples for formulas are: "TODAY()", "IF(C1>0;ABS(C1*D1);"""")", "SUM(E16:E38)" or "E39+E39*E40".

Feedback, Comments & Corrections

XLSheetMBS.WriteFormulaBool(row as Integer, col as Integer, Expression as string, value as Boolean, format as XLFormatMBS = nil) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 16.5 Yes Yes Yes Yes No
Function: Writes a formula expression with precalculated bool value into cell with specified format.
Notes:
If format equals nil then format is ignored.
Returns false if error occurs. Get error info with XLBookMBS.errorMessage.

Feedback, Comments & Corrections

XLSheetMBS.WriteFormulaNum(row as Integer, col as Integer, Expression as string, value as Double, format as XLFormatMBS = nil) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 16.5 Yes Yes Yes Yes No
Function: Writes a formula expression with precalculated double value into cell with specified format.
Notes: If format equals nil then format is ignored. Returns false if error occurs. Get error info with XLBookMBS.errorMessage.

Feedback, Comments & Corrections

XLSheetMBS.WriteFormulaString(row as Integer, col as Integer, Expression as string, value as String, format as XLFormatMBS = nil) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method XL MBS XL Plugin 16.5 Yes Yes Yes Yes No
Function: Writes a formula expression with precalculated string value into cell with specified format.
Notes: If format equals nil then format is ignored. Returns false if error occurs. Get error info with XLBookMBS.errorMessage.

Feedback, Comments & Corrections

XLSheetMBS.WriteNumber(row as Integer, col as Integer, value as Double, format as XLFormatMBS = nil) 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: Writes a number or date/time into cell with specified format.
Notes:
If format is nil then format is ignored. Use XLBookMBS.datePack() for packing date/time parts to double.
Returns false if 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.

Feedback, Comments & Corrections

XLSheetMBS.WriteString(row as Integer, col as Integer, value as string, format as XLFormatMBS = nil) 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: Writes a string into cell with specified format.
Notes:
If format is nil then format is ignored.
Returns false if 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.

Feedback, Comments & Corrections

XLSheetMBS.Zoom 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 zoom level of the current view.
Notes:
100 is a usual view.
(Read and Write computed property)

Feedback, Comments & Corrections

Previous items

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




Links
MBS Xojo Plugins