Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

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

Previous items

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




Links
MBS Xojo PDF Plugins