ExcelReader Xojo Component

ExcelReader.Format Class

A class that represents Excel format. Such as colors, Borders, and other such


class ExcelReader.Format


FormatDefault constructor with no parameters.


AlignmentTextRotationRotation in degrees.
AlignmentWrapTextTrue if text wrap is on, else false.
ApplyAlignmentTrue if alignment is applied.
ApplyBorderIf set to true then Borders are applied to the cell or object.
ApplyFontIf set to true then font is applied to the cell or object.
ApplyNumberFormatIf set to true the numeric format is applied to the cell or object.
BorderBottomReturns the Bottom border object.
BorderDiagonalReturns the diagonal border object.
BorderLeftReturns the Left border object.
BorderRightReturns the Right border object.
BorderTopReturns the Top border object.
FillReturns the fill description or nil if there is no fill set for the given format.
FontBoldIf set to true then Font has bold type face.
FontItalicIf set to true then Font has italic type face.
FontNameReturns the font name.
FontSizeReturns the font size.
FontUnderlineIf set to true then Font has italic type face.
ForegroundColorReturns the foreground color.
FormatCodeIf there is custom number or date-format then this property will contain a format string
HorizontalAlignmentReturns the horizontal alignment for the format.
IndentSets the indent of the cell text.
NumberFormatIDReturns the ID of the number format.
VerticalAlignmentReturns the vertical alignment for the format.


HorizontalAlignmentValuesEnum that represent excel document cell horizontal alignment.
VerticalAlignmentValuesEnum that represent excel document cell vertical alignment.

Supported Platforms:

  • MacOS X Carbon
  • MacOS X Cocoa 32 bit
  • MacOS X Cocoa 64 bit
  • Windows 32 bit
  • Windows 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM