Platforms to show: All Mac Windows Linux Cross-Platform

XLFormatMBS class

Var book as XLBookMBS // your book
// add font
Var boldFont as XLFontMBS = book.addFont()
boldFont.StrikeOut = true

// add format
Var boldFormat as XLFormatMBS = book.addFormat
boldFormat.font = boldFont

// write on a cell in first sheet
sheet = book.Sheet(0)
call sheet.WriteString(1, 1, "Sales Receipt", boldFormat)

• 26 properties
  • property AlignH as Integer
  • property AlignV as Integer
  • property Book as XLBookMBS
  • property BorderBottom as Integer
  • property BorderBottomColor as Integer
  • property BorderDiagonal as Integer
  • property BorderDiagonalColor as Integer
  • property BorderDiagonalStyle as Integer
  • property BorderLeft as Integer
  • property BorderLeftColor as Integer
  • property BorderRight as Integer
  • property BorderRightColor as Integer
  • property BorderTop as Integer
  • property BorderTopColor as Integer
  • property FillPattern as Integer
  • property Font as XLFontMBS
  • property Handle as Integer
  • property Hidden as boolean
  • property Indent as Integer
  • property Locked as boolean
  • property NumFormat as Integer
  • property PatternBackgroundColor as Integer
  • property PatternForegroundColor as Integer
  • property Rotation as Integer
  • property ShrinkToFit as boolean
  • property Wrap as boolean
• 6 methods
  • method Constructor   Private
  • method Operator_Compare(other as XLFontMBS) as Integer
  • method SetBorder(border as Integer = 1)
  • method SetBorderColor(ColorValue as Integer)
  • method SetFont(font as XLFontMBS) as boolean
  • method SetRotation(rotation as Integer) as boolean
• 86 constants

This class has no sub classes.

Some methods using this class:

• XLSheetMBS.ColFormat(col as integer) as XLFormatMBS
• XLSheetMBS.ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
• XLSheetMBS.ReadStyledText(row as integer, col as integer, byref format as XLFormatMBS) as StyledText
• XLSheetMBS.SetRow(row as Integer, height as Double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
• XLSheetMBS.WriteBlank(row as Integer, col as Integer, format as XLFormatMBS = nil) as boolean
• XLSheetMBS.WriteDateTime(row as integer, col as integer, value as dateTime, format as XLFormatMBS = nil) as boolean
• XLSheetMBS.WriteError(row as Integer, col as Integer, Error as Integer, format as XLFormatMBS = nil)
• XLSheetMBS.WriteFormulaString(row as Integer, col as Integer, Expression as string, value as String, format as XLFormatMBS = nil) as boolean
• XLSheetMBS.WriteNumber(row as Integer, col as Integer, value as Double, format as XLFormatMBS = nil) as boolean
• XLSheetMBS.WriteStringAsNumber(row as integer, col as integer, value as string, format as XLFormatMBS = nil) as boolean

Some properties using for this class:

• XLSheetMBS.CellFormat(row as Integer, col as Integer) as XLFormatMBS

Some examples using this class:

• /XL/Custom Number Formats
• /XL/Format
• /XL/Generate
• /XL/Invoice
• /XL/Invoice xml
• /XL/Writing data

Blog Entries

• MBS Xojo Plugins, version 24.2pr1
• LibXL Extras for Xojo
• MBS Xojo Plugins, version 18.4pr9

Xojo Developer Magazine

• 20.5, page 73: Create and Read Excel Spreadsheets, Using LibXL with Xojo by Stefanie Juchmes

Release notes

• Version 24.2
  • Added Operator_Compare method to XLFontMBS and XLFormatMBS classes.
  • Improved XLFontMBS and XLFormatMBS handling for our XL Plugin to cache the objects and reuse them.
• Version 18.4
  • Changed properties in XLAutoFilterMBS, XLBookMBS, XLFilterColumnMBS, XLFontMBS, XLFormatMBS and XLSheetMBS class to be visible in debugger.

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

XLFontMBS   -   XLFormControlMBS