Platforms to show: All Mac Windows Linux Cross-Platform

XL

Classes for reading excel files.

• Classes
  • class XLAutoFilterMBS
    • method AddSort(columnIndex as Integer, descending as boolean) as Boolean
    • method Column(colId as Integer) as XLFilterColumnMBS
    • method ColumnByIndex(colId as Integer) as XLFilterColumnMBS
    • method Constructor
    • method GetRef(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
    • method GetSort(byref columnIndex as Integer, byref descending as Boolean) as Boolean
    • method GetSortRange(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
    • method SetRef(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
    • method SetSort(columnIndex as Integer, descending as Boolean) as Boolean
    • property Book as XLBookMBS
    • property ColumnSize as Integer
    • property Handle as Integer
  • class XLBookMBS
    • method AddConditionalFormat as XLConditionalFormatMBS
    • method AddCustomNumFormat(customNumFormat as string) as Integer
    • method AddFont(initFont as XLFontMBS = nil) as XLFontMBS
    • method AddFormat(initFormat as XLFormatMBS = nil) as XLFormatMBS
    • method AddFormatFromStyle(style as Integer) as XLFormatMBS
    • method AddPicture(path as folderitem) as Integer
    • method AddPicture(path as string) as Integer
    • method AddPictureData(data as string) as Integer
    • method AddRichString as XLRichStringMBS
    • method AddSheet(name as string, initSheet as XLSheetMBS = nil) as XLSheetMBS
    • method AddStyledText(StyledText as StyledText) as XLRichStringMBS
    • shared method available as boolean
    • method BookRemoveVBA as boolean
    • method BookVersion as Integer
    • method Clear
    • method ConditionalFormat(index as integer) as XLConditionalFormatMBS
    • method ConditionalFormats as XLConditionalFormatMBS()
    • method Constructor(xml as boolean = false)
    • method CopyContent(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)
    • method CoreProperties as XLCorePropertiesMBS
    • method CustomNumFormat(fmt as Integer) as string
    • method DefaultFont(byref fontSize as Integer) as string
    • method DelSheet(index as Integer) as boolean
    • method Font(index as Integer) as XLFontMBS
    • method FontCount as Integer
    • method Fonts as XLFontMBS()
    • method Format(index as Integer) as XLFormatMBS
    • method FormatCount as Integer
    • method Formats as XLFormatMBS()
    • method InsertSheet(index as Integer, name as string = "", initSheet as XLSheetMBS = nil) as XLSheetMBS
    • shared method LibVersion as string
    • shared method LibVersionNumber as Integer
    • method Load(path as folderitem) as boolean
    • method Load(path as string) as boolean
    • shared method Load2(path as folderitem) as XLBookMBS
    • shared method Load2(path as folderitem, byref ErrorMessage as String) as XLBookMBS
    • shared method Load2(path as string) as XLBookMBS
    • shared method Load2(path as string, byref ErrorMessage as String) as XLBookMBS
    • shared method LoadError as String
    • method LoadInfo(path as folderitem) as boolean
    • method LoadInfo(path as string) as boolean
    • method LoadInfoRaw(data as MemoryBlock) as boolean
    • method LoadInfoRaw(data as string) as boolean
    • shared method LoadLibrary(File as FolderItem) as boolean
    • shared method LoadLibrary(Path as string) as boolean
    • method LoadMT(path as folderitem) as boolean
    • method LoadMT(path as string) as boolean
    • method LoadPartially(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
    • method LoadPartially(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
    • method LoadPartiallyUsingTempFile(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as folderitem, keepAllSheets as Boolean = false) as boolean
    • method LoadPartiallyUsingTempFile(path as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as String, keepAllSheets as Boolean = false) as boolean
    • method LoadRaw(data as MemoryBlock) as boolean
    • method LoadRaw(data as string) as boolean
    • shared method LoadRaw2(data as MemoryBlock) as XLBookMBS
    • shared method LoadRaw2(data as MemoryBlock, byref ErrorMessage as String) as XLBookMBS
    • shared method LoadRaw2(data as string) as XLBookMBS
    • shared method LoadRaw2(data as string, byref ErrorMessage as String) as XLBookMBS
    • method LoadRawMT(data as MemoryBlock) as boolean
    • method LoadRawMT(data as string) as boolean
    • method LoadRawPartially(data as MemoryBlock, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
    • method LoadRawPartially(data as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
    • method LoadUsingTempFile(path as folderitem, TempFile as folderitem) as boolean
    • method LoadUsingTempFile(path as string, TempFile as String) as boolean
    • method MoveSheet(SourceIndex as integer, DestIndex as Integer) as boolean
    • method PackColor(ColorValue as color) as Integer
    • method PackColor(red as Integer, green as Integer, blue as Integer) as Integer
    • method PackDate(d as date) as Double
    • method PackDate(year as Integer, month as Integer, day as Integer, hour as Integer = 0, min as Integer = 0, sec as Integer = 0, msec as Integer = 0) as Double
    • method PackDateTime(d as dateTime) as double
    • method Picture(index as Integer, byref data as string) as Integer
    • method PictureCount as Integer
    • method RemoveAllPhonetics
    • method RemovePrinterSettings as boolean
    • method Save(path as folderitem) as boolean
    • method Save(path as folderitem, UseTempFile as Boolean) as boolean
    • method Save(path as string) as boolean
    • method Save(path as string, UseTempFile as Boolean) as boolean
    • method SaveMT(path as folderitem) as boolean
    • method SaveMT(path as string) as boolean
    • method SaveRaw(byref data as MemoryBlock) as boolean
    • method SaveRaw(byref data as string) as boolean
    • method SaveRawMT(byref data as MemoryBlock) as boolean
    • method SaveRawMT(byref data as string) as boolean
    • method SetDefaultFont(fontName as string, fontSize as Integer)
    • method SetKey(name as string, key as string)
    • shared method SetKeyGlobal(name as string, key as string)
    • method SetKeyGlobal(name as string, key as string)
    • method SetLocale(locale as string)
    • method SetPassword(Password as String)
    • method Sheet(index as Integer) as XLSheetMBS
    • method SheetCount as Integer
    • method SheetName(index as integer) as String
    • method Sheets as XLSheetMBS()
    • method SheetType(index as Integer) as Integer
    • method UnpackColor(ColorValue as Integer) as color
    • method UnpackColor(ColorValue as Integer, byref red as Integer, byref green as Integer, byref blue as Integer)
    • method UnpackDate(Value as Double) as date
    • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer) as boolean
    • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer, byref hour as Integer, byref min as Integer, byref sec as Integer) as boolean
    • method UnpackDate(Value as Double, byref year as Integer, byref month as Integer, byref day as Integer, byref hour as Integer, byref min as Integer, byref sec as Integer, byref msec as Integer) as boolean
    • method UnpackDateTime(Value as double) as dateTime
    • property ActiveSheet as Integer
    • property BiffVersion as Integer
    • property CalcMode as integer
    • property ConditionalFormatSize as Integer
    • property ErrorCode as Integer
    • Property ErrorMessage as string
    • property Handle as Integer
    • property IsDate1904 as boolean
    • property IsTemplate as boolean
    • property IsWriteProtected as Boolean
    • property RefR1C1 as Integer
    • property RgbMode as boolean
  • class XLConditionalFormatMBS
    • method Constructor
    • method SetBorder(style as Integer = 1)
    • method SetBorderColor(color as Integer)
    • property Book as XLBookMBS
    • property BorderBottom as Integer
    • property BorderBottomColor 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 CustomNumFormat as String
    • property FillPattern as Integer
    • property Font as XLFontMBS
    • property Handle as Integer
    • property NumFormat as Integer
    • property PatternBackgroundColor as Integer
    • property PatternForegroundColor as Integer
  • class XLConditionalFormattingMBS
    • method Add2ColorScaleFormulaRule(minColor as Integer, maxColor as Integer, minType as Integer = 2, minValue as String = "", maxType as Integer = 2, maxValue as String = "", stopIfTrue as Boolean = false)
    • method Add2ColorScaleRule(minColor as Integer, maxColor as Integer, minType as Integer = 0, minValue as Double = 0, maxType as Integer = 1, maxValue as Double = 0, stopIfTrue as Boolean = false)
    • method Add3ColorScaleFormulaRule(minColor as Integer, midColor as Integer, maxColor as Integer, minType as Integer = 2, minValue as String = "", midType as Integer = 2, midValue as String = "", maxType as Integer = 2, maxValue as String = "", stopIfTrue as Boolean = false)
    • method Add3ColorScaleRule(minColor as Integer, midColor as Integer, maxColor as Integer, minType as Integer = 0, minValue as Double = 0, midType as Integer = 5, midValue as Double = 0, maxType as Integer = 1, maxValue as Double = 0, stopIfTrue as Boolean = false)
    • method AddAboveAverageRule(format as XLConditionalFormatMBS, aboveAverage as Boolean = true, equalAverage as Boolean = false, stdDev as Integer = 0, stopIfTrue as Boolean = false)
    • method AddOpNumRule(op as Integer, format as XLConditionalFormatMBS, value1 as double, value2 as double = 0.0, stopIfTrue as Boolean = false)
    • method AddOpStrRule(op as Integer, format as XLConditionalFormatMBS, value1 as String = "", value2 as String = "", stopIfTrue as Boolean = false)
    • method AddRange(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
    • method AddRule(FormatType as Integer, format as XLConditionalFormatMBS, value as String = "", stopIfTrue as Boolean = false)
    • method AddTimePeriodRule(format as XLConditionalFormatMBS, timePeriod as Integer, stopIfTrue as Boolean = false)
    • method AddTopRule(format as XLConditionalFormatMBS, value as Integer, bottom as Boolean = false, percent as Boolean = false, stopIfTrue as Boolean = false)
    • method Constructor
    • property Book as XLBookMBS
    • property Handle as Integer
    • property RuleCount as Integer
  • class XLCopyOptionsMBS
    • method Constructor
    • property CopyColHidden as Boolean
    • property CopyComments as Boolean
    • property CopyFormat as Boolean
    • property CopyHorPageBreak as Boolean
    • property CopyMerge as Boolean
    • property CopyNamedRanges as Boolean
    • property CopyPicture as Boolean
    • property CopyPrintArea as Boolean
    • property CopyPrintFit as Boolean
    • property CopyPrintRepeat as Boolean
    • property CopyRowHidden as Boolean
  • class XLCorePropertiesMBS
    • method Constructor
    • method RemoveAll
    • property Book as XLBookMBS
    • property Categories as String
    • property Comments as String
    • property Created as String
    • property CreatedAsDouble as Double
    • property Creator as String
    • property Handle as Integer
    • property LastModifiedBy as String
    • property Modified as String
    • property ModifiedAsDouble as Double
    • property Subject as String
    • property Tags as String
    • property Title as String
  • class XLFilterColumnMBS
    • method AddFilter(Filter as String)
    • method Clear
    • method Constructor
    • method Filter(index as Integer) as String
    • method GetCustomFilterEx(byref Op1 as Integer, byref Value1 as String, byref Op2 as Integer, byref Value2 as String, byref andOp as Boolean) as boolean
    • method GetTop10(byref value as Double, byref top as boolean, byref percent as boolean) as boolean
    • method SetCustomFilter(Op as Integer, Value as String)
    • method SetCustomFilterEx(Op1 as Integer, Value1 as String, Op2 as Integer, Value2 as String, andOp as Boolean = false)
    • method SetTop10(value as Double, top as boolean = true, percent as boolean = false)
    • property Book as XLBookMBS
    • property FilterSize as Integer
    • property FilterType as Integer
    • property Handle as Integer
    • property Index as Integer
  • class XLFontMBS
    • method Constructor
    • method Operator_Compare(other as XLFontMBS) as Integer
    • property Bold as Boolean
    • property Book as XLBookMBS
    • property ColorRGB as Color
    • property ColorValue as Integer
    • property Handle as Integer
    • property Italic as Boolean
    • property Name as string
    • property Script as Integer
    • property Size as Integer
    • property StrikeOut as Boolean
    • property Underline as Integer
  • class XLFormatMBS
    • method Constructor
    • 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
    • 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
  • class XLFormControlMBS
    • method AddItem(value as String)
    • method ClearItems
    • method Constructor
    • method FromAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
    • method InsertItem(Index as Integer, value as String)
    • method Item(Index as Integer) as String
    • method ToAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
    • property AltText as String
    • property Book as XLBookMBS
    • property Checked as Integer
    • property DefaultSize as Boolean
    • property Disabled as Boolean
    • property DropLines as Integer
    • property Dx as Integer
    • property FirstButton as Boolean
    • property FmlaGroup as String
    • property FmlaLink as String
    • property FmlaRange as String
    • property FmlaTxbx as String
    • property Handle as Integer
    • property Horiz as Integer
    • property Inc as Integer
    • property ItemCount as Integer
    • property LinkedCell as String
    • property ListFillRange as String
    • property Locked as Boolean
    • property Macro as String
    • property Max as Integer
    • property Min as Integer
    • property MultiSel as String
    • property Name as String
    • property ObjectType as Integer
    • property Print as Boolean
    • property Sel as Integer
  • class XLRichStringMBS
    • method AddFont(templateFont as XLFontMBS = nil) as XLFontMBS
    • method AddStyledText(StyledText as StyledText)
    • method AddText(text as String, font as XLFontMBS = nil)
    • method Constructor(book as XLBookMBS)
    • method Text(Index as Integer) as String
    • method Text(Index as Integer, byref font as XLFontMBS) as String
    • property Book as XLBookMBS
    • property Handle as Integer
    • property StyledText as StyledText
    • property Text as String
    • property TextCount as Integer
  • class XLSheetMBS
    • method AddConditionalFormatting(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer) as XLConditionalFormattingMBS
    • method AddDataValidation(type as Integer, op as integer, rowFirst as integer, colFirst as integer, rowLast as integer, colLast as integer, value1 as String, value2 as String)
    • method AddDataValidation(type as Integer, op as integer, rowFirst as integer, colFirst as integer, rowLast as integer, colLast as integer, value1 as String, value2 as String, allowBlank as Boolean, hideDropDown as Boolean = false, showInputMessage as Boolean = true, showErrorMessage as Boolean = true, promptTitle as String = "", prompt as String = "", errorTitle as string = "", error as string = "", errorStyle as integer = 0)
    • method AddDataValidationDouble(type as Integer, op as integer, rowFirst as integer, colFirst as integer, rowLast as integer, colLast as integer, value1 as Double, value2 as Double)
    • method AddDataValidationDouble(type as Integer, op as integer, rowFirst as integer, colFirst as integer, rowLast as integer, colLast as integer, value1 as Double, value2 as Double, allowBlank as Boolean, hideDropDown as Boolean = false, showInputMessage as Boolean = true, showErrorMessage as Boolean = true, promptTitle as String = "", prompt as String = "", errorTitle as string = "", error as string = "", errorStyle as integer = 0)
    • method AddHyperlink(hyperlink as string, rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
    • method AddIgnoredError(rowFirst as Integer, colFirst as Integer, rowLast as Integer, colLast as Integer, iError as Integer) as Boolean
    • method AddrToRowCol(addr as string, byref row as Integer, byref col as Integer, byref rowRelative as boolean, byref colRelative as boolean)
    • method AddSelectionRange(sqref as string)
    • method AddTable(Name as String, rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer, hasHeaders as Boolean, tableStyle as Integer) as XLTableMBS
    • method ApplyFilter
    • method ApplyFilter(AutoFilter as XLAutoFilterMBS)
    • method CellType(row as Integer, col as Integer) as Integer
    • method Clear(rowFirst as Integer = 0, rowLast as Integer = 1048575, colFirst as Integer = 0, colLast as Integer = 16383) as Boolean
    • method ClearPrintArea
    • method ClearPrintRepeats
    • method ColFormat(col as integer) as XLFormatMBS
    • method ColWidth(col as Integer) as Double
    • method ColWidthPx(col as integer) as Integer
    • method ConditionalFormatting(index as integer) as XLConditionalFormattingMBS
    • method ConditionalFormattings as XLConditionalFormattingMBS()
    • method Constructor
    • method CopyCell(rowSrc as Integer, colSrc as Integer, rowDst as Integer, colDst as Integer) as boolean
    • method CopyCellValue(dest as XLSheetMBS, SourceRow as Integer, DestRow as Integer, SourceColumn as Integer, DestColumn as Integer, Options as XLCopyOptionsMBS = nil)
    • method CopyColumn(dest as XLSheetMBS, SourceColumn as Integer, DestColumn as Integer, Options as XLCopyOptionsMBS = nil)
    • method CopyRow(dest as XLSheetMBS, SourceRow as Integer, DestRow as Integer, Options as XLCopyOptionsMBS = nil)
    • method CopySheet(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)
    • method CopySheet(dest as XLSheetMBS, Options as XLCopyOptionsMBS = nil)
    • method DelHyperlink(index as Integer) as Boolean
    • method DelMerge(row as Integer, col as Integer) as boolean
    • method DelMergeByIndex(index as Integer) as Boolean
    • method DelNamedRange(name as string, scopeId as Integer = -2) as boolean
    • method FormControl(index as integer) as XLFormControlMBS
    • method FormControls as XLFormControlMBS()
    • method GetActiveCell(byref row as integer, byref col as integer) as boolean
    • method GetHorPageBreak(index as Integer) as Integer
    • method GetMerge(row as Integer, col as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as boolean
    • method GetNamedRange(name as string, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as boolean
    • method GetNamedRange(name as string, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer, ScopeID as Integer, byref Hidden as Integer) as boolean
    • method GetPicture(index as Integer, byref rowTop as Integer, byref colLeft as Integer, byref rowBottom as Integer, byref colRight as Integer, byref width as Integer, byref height as Integer, byref offsetX as Integer, byref offsetY as Integer) as Integer
    • method GetPrintArea(byref rowFirst as Integer, byref colFirst as Integer, byref rowLast as Integer, byref colLast as Integer) as boolean
    • method GetPrintFit(byref wPages as Integer, byref hPages as Integer) as boolean
    • method GetPrintRepeatCols(byref colFirst as Integer, byref colLast as Integer) as boolean
    • method GetPrintRepeatRows(byref rowFirst as Integer, byref rowLast as Integer) as boolean
    • method GetTabRgbColor(byref red as Integer, byref green as Integer, byref blue as Integer) as Boolean
    • method GetTopLeftView(byref row as Integer, byref col as Integer)
    • method GetVerPageBreak(index as Integer) as Integer
    • method GroupCols(colFirst as Integer, colLast as Integer, collapsed as boolean = true) as boolean
    • method GroupRows(rowFirst as Integer, rowLast as Integer, collapsed as boolean = true) as boolean
    • method Hyperlink(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as String
    • method HyperlinkIndex(row as integer, col as integer) as Integer
    • method InsertCol(colFirst as Integer, colLast as Integer) as boolean
    • method InsertColAndKeepRanges(colFirst as integer, colLast as integer) as boolean
    • method InsertRow(rowFirst as Integer, rowLast as Integer) as boolean
    • method InsertRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean
    • method IsAutoFilter as boolean
    • method IsDate(row as Integer, col as Integer) as boolean
    • method IsFormula(row as Integer, col as Integer) as boolean
    • method IsRichString(row as integer, col as integer) as Boolean
    • method Merge(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
    • method NamedRange(index as Integer, byref rowFirst as Integer, byref rowLast as Integer, byref ColFirst as Integer, byref ColLast as Integer) as string
    • method 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
    • method ReadBlank(row as Integer, col as Integer) as boolean
    • method ReadBlank(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
    • method ReadBoolean(row as Integer, col as Integer) as boolean
    • method ReadBoolean(row as Integer, col as Integer, byref format as XLFormatMBS) as boolean
    • method ReadComment(row as Integer, col as Integer) as string
    • method ReadDate(row as Integer, col as Integer) as date
    • method ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date
    • method ReadDateTime(row as integer, col as integer) as dateTime
    • method ReadDateTime(row as integer, col as integer, byref format as XLFormatMBS) as dateTime
    • method ReadError(row as Integer, col as Integer) as Integer
    • method ReadFormula(row as Integer, col as Integer) as string
    • method ReadFormula(row as Integer, col as Integer, byref format as XLFormatMBS) as string
    • method ReadNumber(row as Integer, col as Integer) as Double
    • method ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double
    • method ReadRichString(row as integer, col as integer) as XLRichStringMBS
    • method ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS
    • method ReadString(row as Integer, col as Integer) as string
    • method ReadString(row as Integer, col as Integer, byref format as XLFormatMBS) as string
    • method ReadStyledText(row as integer, col as integer) as StyledText
    • method ReadStyledText(row as integer, col as integer, byref format as XLFormatMBS) as StyledText
    • method ReadValue(row as integer, col as integer) as Variant
    • method ReadValue(row as integer, col as integer, byref format as XLFormatMBS) as Variant
    • method RemoveCol(colFirst as Integer, colLast as Integer) as boolean
    • method RemoveColAndKeepRanges(colFirst as integer, colLast as integer) as boolean
    • method RemoveComment(row as Integer, col as Integer)
    • method RemoveConditionalFormatting(index as Integer) as Boolean
    • method RemoveDataValidations
    • method RemoveFilter
    • method RemovePicture(row as integer, col as integer) as Boolean
    • method RemovePictureByIndex(index as integer) as Boolean
    • method RemoveRow(rowFirst as Integer, rowLast as Integer) as boolean
    • method RemoveRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean
    • method RemoveSelection
    • method RowColToAddr(row as Integer, col as Integer, rowRelative as boolean = true, colRelative as boolean = true) as string
    • method RowFormat(row as integer) as XLFormatMBS
    • method RowHeight(row as Integer) as Double
    • method RowHeightPx(row as integer) as Integer
    • method SelectionRange as string
    • method SetActiveCell(row as integer, col as integer)
    • method SetAutoFitArea(rowFirst as Integer = 0, colFirst as Integer = 0, rowLast as Integer = -1, colLast as Integer = -1)
    • method SetBorder(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer, borderStyle as Integer, borderColor as Integer)
    • method SetCol(colFirst as Integer, colLast as Integer, width as Double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
    • method SetColPx(colFirst as integer, colLast as integer, width as integer, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
    • method SetFooter(footer as string, margin as Double) as boolean
    • method SetHeader(header as string, margin as Double) as boolean
    • method SetHorPageBreak(row as Integer, pageBreak as boolean = true) as boolean
    • method SetMerge(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer) as boolean
    • method SetNamedRange(name as string, rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer, scopeId as Integer = -2) as boolean
    • method SetPicture(row as Integer, col as Integer, PictureID as Integer, scale as Double = 1.0, OffsetX as Integer = 0, OffsetY as Integer = 0, pos as Integer = 0)
    • method SetPicture(row as Integer, col as Integer, PictureID as Integer, width as Integer, height as Integer, OffsetX as Integer = 0, OffsetY as Integer = 0, pos as Integer = 0)
    • method SetPrintArea(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
    • method SetPrintFit(wPages as Integer, hPages as Integer)
    • method SetPrintRepeatCols(colFirst as Integer, colLast as Integer)
    • method SetPrintRepeatRows(rowFirst as Integer, rowLast as Integer)
    • method SetProtectEx(protect as boolean = true, password as string = "", enhancedProtection as Integer = -1)
    • method SetRow(row as Integer, height as Double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
    • method SetRowPx(row as integer, height as integer, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
    • method SetTabColor(colorValue as Integer)
    • method SetTabRgbColor(red as Integer, green as Integer, blue as Integer)
    • method SetTopLeftView(row as Integer, col as Integer)
    • method SetVerPageBreak(row as Integer, pageBreak as boolean = true) as boolean
    • method Split(row as Integer, col as Integer)
    • method SplitInfo(byref row as Integer, byref col as Integer) as Boolean
    • method 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
    • method Table(name as string, 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 Boolean
    • method TableByIndex(index as Integer) as XLTableMBS
    • method TableByName(Name as String) as XLTableMBS
    • method Tables as XLTableMBS()
    • method WriteBlank(row as Integer, col as Integer, format as XLFormatMBS = nil) as boolean
    • method WriteBoolean(row as Integer, col as Integer, value as boolean, format as XLFormatMBS = nil) as boolean
    • method WriteComment(row as Integer, col as Integer, value as string, author as string, width as Integer, height as Integer)
    • method WriteDate(row as Integer, col as Integer, value as date, format as XLFormatMBS = nil) as boolean
    • method WriteDateTime(row as integer, col as integer, value as dateTime, format as XLFormatMBS = nil) as boolean
    • method WriteError(row as Integer, col as Integer, Error as Integer, format as XLFormatMBS = nil)
    • method WriteFormula(row as Integer, col as Integer, value as string, format as XLFormatMBS = nil) as boolean
    • method WriteFormulaBool(row as Integer, col as Integer, Expression as string, value as Boolean, format as XLFormatMBS = nil) as boolean
    • method WriteFormulaNum(row as Integer, col as Integer, Expression as string, value as Double, format as XLFormatMBS = nil) as boolean
    • method WriteFormulaString(row as Integer, col as Integer, Expression as string, value as String, format as XLFormatMBS = nil) as boolean
    • method WriteNumber(row as Integer, col as Integer, value as Double, format as XLFormatMBS = nil) as boolean
    • method WriteRichString(row as integer, col as integer, RichString as XLRichStringMBS, format as XLFormatMBS = nil) as boolean
    • method WriteString(row as Integer, col as Integer, value as string, format as XLFormatMBS = nil) as boolean
    • method WriteStringAsNumber(row as integer, col as integer, value as string, format as XLFormatMBS = nil) as boolean
    • method WriteStyledText(row as integer, col as integer, StyledText as StyledText, format as XLFormatMBS = nil) as boolean
    • property AutoFilter as XLAutoFilterMBS
    • property Book as XLBookMBS
    • property ConditionalFormattingSize as Integer
    • property DefaultRowHeight as Double
    • property DisplayGridlines as boolean
    • property FirstCol as Integer
    • property FirstFilledCol as Integer
    • property FirstFilledRow as Integer
    • property FirstRow as Integer
    • property Footer as string
    • property FooterMargin as Double
    • property FormControlCount as Integer
    • property GetHorPageBreakCount as Integer
    • property GetVerPageBreakCount as Integer
    • property GroupSummaryBelow as boolean
    • property GroupSummaryRight as boolean
    • property Handle as Integer
    • property HCenter as boolean
    • property Header as string
    • property HeaderMargin as Double
    • property Hidden as Integer
    • property HyperlinkSize as Integer
    • property Landscape as boolean
    • property LastCol as Integer
    • property LastFilledCol as Integer
    • property LastFilledRow as Integer
    • property LastRow as Integer
    • property MarginBottom as Double
    • property MarginLeft as Double
    • property MarginRight as Double
    • property MarginTop as Double
    • property MergeSize as Integer
    • property Name as string
    • property NamedRangeCount as Integer
    • property Paper as Integer
    • property PictureCount as Integer
    • property PrintGridlines as boolean
    • property PrintRowCol as boolean
    • property PrintZoom as Integer
    • property Protect as boolean
    • property RightToLeft as boolean
    • property TabColor as Integer
    • property TableSize as Integer
    • property VCenter as boolean
    • property Zoom as Integer
    • property CellFormat(row as Integer, col as Integer) as XLFormatMBS
    • property ColHidden(col as Integer) as boolean
    • property RowHidden(row as Integer) as boolean
  • class XLTableMBS
    • method Constructor
    • property AutoFilter as XLAutoFilterMBS
    • property Book as XLBookMBS
    • property ColumnSize as Integer
    • property Handle as Integer
    • property Name as String
    • property Ref as String
    • property ShowColumnStripes as Boolean
    • property ShowFirstColumn as Boolean
    • property ShowLastColumn as Boolean
    • property ShowRowStripes as Boolean
    • property Style as Integer
    • property ColumnName(columnIndex as Integer) as String
• Blog Entries
  • News from the MBS Xojo Plugins Version 25.2
  • News from the MBS Xojo Plugins in version 21.5
  • MBS Xojo Plugins, version 21.5pr1
  • LibXL Extras for Xojo
  • MBS Xojo Plugins, version 18.4pr9

Release notes

• Version 26.1
  • Changed AddConditionalFormat function in XLSheetMBS class to take area as parameters.
  • Added RemoveConditionalFormatting method to XLSheetMBS class.
  • Added ConditionalFormattings, ConditionalFormatting and ConditionalFormattingSize to XLSheetMBS class.
  • Added ConditionalFormats, ConditionalFormat and ConditionalFormatSize to XLBookMBS class.
  • Added ErrorCode property to XLBookMBS class.
  • Added Clear method to XLBookMBS class.
  • Added Tables and FormControls to XLSheetMBS class.
  • Added LoadInfo and LoadInfoRaw methods to XLBookMBS class.
• Version 26.0
  • Added SetPassword method for XLBookMBS class to read encrypted Excel workbooks.
• Version 25.2
  • Added AddTable, ApplyFilter, SetBorder, TableByIndex and TableByName methods to XLSheetMBS class.
  • Added XLTableMBS class.
• Version 25.1
  • Changed SetLicenseKey in XLBookMBS class to raise exception if you pass invalid license, e.g. Windows license on macOS, instead of ignoring it.
• Version 25.0
  • Added RemoveAllPhonetics and CoreProperties methods to XLBookMBS class.
  • Added RowFormat and ColFormat functions to XLSheetMBS class.
  • Added XLCorePropertiesMBS class.
• Version 24.4
  • Fixed a crash in AddConditionalFormatting method in XLSheetMBS class.
  • Fixed a crash in WriteStyledText method in XLSheetMBS class.
• Version 24.3
  • Fixed a problem with XLBookMBS when using conditional formatting.
• Version 24.2
  • Added XLConditionalFormattingMBS and XLConditionalFormatMBS classes.
  • Added keepAllSheets parameter for LoadPartially methods in XLBookMBS class.
  • Added Operator_Compare method to XLFontMBS and XLFormatMBS classes.
  • Added PictureTypeSVG constant for XLBookMBS class.
  • Improved XLFontMBS and XLFormatMBS handling for our XL Plugin to cache the objects and reuse them.
• Version 23.3
  • Added AddFormatFromStyle method for XLBookMBS class.
  • Added Table, SetRowPx and SetColPx methods for XLSheetMBS class.

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