Platforms to show: All Mac Windows Linux Cross-Platform

The plugin MBS XL Plugin:

• class XLAutoFilterMBS
  • method AddSort(columnIndex as Integer, descending as boolean) as Boolean
  • method GetSort(byref columnIndex as Integer, byref descending as Boolean) as Boolean
  • method SetSort(columnIndex as Integer, 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 GetRef(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 ColumnByIndex(colId as Integer) as XLFilterColumnMBS
  • method Column(colId as Integer) as XLFilterColumnMBS
  • method Constructor
  • property Handle as Integer
  • property Book as XLBookMBS
  • property ColumnSize as Integer
• class XLBookMBS
  • method CoreProperties as XLCorePropertiesMBS
  • method RemoveAllPhonetics
  • method BookRemoveVBA as boolean
  • method RemovePrinterSettings as boolean
  • method AddConditionalFormat as XLConditionalFormatMBS
  • method AddStyledText(StyledText as StyledText) as XLRichStringMBS
  • method AddRichString as XLRichStringMBS
  • method LoadRawPartially(data as string, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, keepAllSheets as Boolean = false) as boolean
  • method LoadRawPartially(data as MemoryBlock, 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 LoadPartially(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, 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 LoadPartiallyUsingTempFile(path as folderitem, sheetIndex as Integer, firstRow as Integer, lastRow as Integer, TempFile as folderitem, keepAllSheets as Boolean = false) as boolean
  • method Save(path as string, UseTempFile as Boolean) as boolean
  • method Save(path as folderitem, UseTempFile as Boolean) as boolean
  • method LoadUsingTempFile(path as string, TempFile as String) as boolean
  • method LoadUsingTempFile(path as folderitem, TempFile as folderitem) as boolean
  • method MoveSheet(SourceIndex as integer, DestIndex as Integer) as boolean
  • method SheetType(index as integer) as integer
  • method BookVersion as integer
  • method Sheets as XLSheetMBS()
  • method Formats as XLFormatMBS()
  • method Fonts as XLFontMBS()
  • method SetLocale(locale as string)
  • method AddCustomNumFormat(customNumFormat as string) as integer
  • method CustomNumFormat(fmt as integer) as string
  • method AddFormat(initFormat as XLFormatMBS = nil) as XLFormatMBS
  • method AddFormatFromStyle(style as Integer) as XLFormatMBS
  • method AddFont(initFont as XLFontMBS = nil) as XLFontMBS
  • method AddPicture(path as folderitem) as integer
  • method AddPicture(path as string) as integer
  • method AddPictureData(data as string) as integer
  • method Picture(index as integer, byref data as string) as integer
  • method PictureCount as integer
  • method InsertSheet(index as integer, name as string = "", initSheet as XLSheetMBS = nil) as XLSheetMBS
  • method AddSheet(name as string, initSheet as XLSheetMBS = nil) as XLSheetMBS
  • method DefaultFont(byref fontSize as integer) as string
  • method SetDefaultFont(fontName as string, fontSize as integer)
  • method PackDate(d as date) as double
  • method UnpackDate(Value as double) as date
  • 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 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 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) as boolean
  • 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 PackColor(ColorValue as color) as integer
  • method PackColor(red as integer, green as integer, blue as integer) as integer
  • method SetKey(name as string, key as string)
  • method Font(index as integer) as XLFontMBS
  • method FontCount as integer
  • method Format(index as integer) as XLFormatMBS
  • method FormatCount as integer
  • method Sheet(index as integer) as XLSheetMBS
  • method SheetCount as integer
  • method DelSheet(index as integer) as boolean
  • method Save(path as string) as boolean
  • method Save(path as folderitem) as boolean
  • method Load(path as string) as boolean
  • method Load(path as folderitem) as boolean
  • method SaveRaw(byref data as string) as boolean
  • method SaveRaw(byref data as MemoryBlock) as boolean
  • method LoadRaw(data as string) as boolean
  • method LoadRaw(data as MemoryBlock) as boolean
  • method Constructor(xml as boolean = false)
  • method CopyContent(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)
  • method SaveMT(path as string) as boolean
  • method SaveMT(path as folderitem) as boolean
  • method LoadMT(path as string) as boolean
  • method LoadMT(path as folderitem) as boolean
  • method SaveRawMT(byref data as string) as boolean
  • method SaveRawMT(byref data as MemoryBlock) as boolean
  • method LoadRawMT(data as string) as boolean
  • method LoadRawMT(data as MemoryBlock) as boolean
  • method SetKeyGlobal(name as string, key as string)
  • method PackDateTime(d as dateTime) as double
  • method UnpackDateTime(Value as double) as dateTime
  • property Handle as Integer
  • property ErrorMessage as String
  • property IsTemplate as Boolean
  • property IsWriteProtected as Boolean
  • property IsDate1904 as Boolean
  • property RgbMode as Boolean
  • property CalcMode as Integer
  • property ActiveSheet as Integer
  • property RefR1C1 as Integer
  • property BiffVersion as Integer
  • shared method LoadLibrary(Path as string) as boolean
  • shared method LoadLibrary(File as FolderItem) as boolean
  • shared method LoadError as String
  • shared method Load2(path as string) as XLBookMBS
  • shared method Load2(path as folderitem) as XLBookMBS
  • shared method LoadRaw2(data as string) as XLBookMBS
  • shared method LoadRaw2(data as MemoryBlock) as XLBookMBS
  • shared method Load2(path as string, byref ErrorMessage as String) as XLBookMBS
  • shared method Load2(path as folderitem, byref ErrorMessage as String) as XLBookMBS
  • shared method LoadRaw2(data as string, byref ErrorMessage as String) as XLBookMBS
  • shared method LoadRaw2(data as MemoryBlock, byref ErrorMessage as String) as XLBookMBS
  • shared method LibVersion as string
  • shared method LibVersionNumber as Integer
  • shared method available as boolean
  • shared method SetKeyGlobal(name as string, key as string)
• class XLConditionalFormatMBS
  • method Constructor
  • method SetBorder(style as Integer = 1)
  • method SetBorderColor(color as Integer)
  • property Handle as Integer
  • property Book as XLBookMBS
  • property Font as XLFontMBS
  • property NumFormat as Integer
  • property CustomNumFormat as String
  • property BorderLeft as Integer
  • property BorderRight as Integer
  • property BorderTop as Integer
  • property BorderBottom as Integer
  • property BorderLeftColor as Integer
  • property BorderRightColor as Integer
  • property BorderTopColor as Integer
  • property BorderBottomColor as Integer
  • property FillPattern as Integer
  • property PatternForegroundColor as Integer
  • property PatternBackgroundColor as Integer
• class XLConditionalFormattingMBS
  • method Constructor
  • 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 AddTopRule(format as XLConditionalFormatMBS, value as Integer, bottom as Boolean = false, percent as Boolean = false, 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 AddAboveAverageRule(format as XLConditionalFormatMBS, aboveAverage as Boolean = true, equalAverage as Boolean = false, stdDev as Integer = 0, stopIfTrue as Boolean = false)
  • method AddTimePeriodRule(format as XLConditionalFormatMBS, timePeriod as Integer, 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 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 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 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)
  • property Handle as Integer
  • property Book as XLBookMBS
  • property RuleCount as Integer
• class XLCopyOptionsMBS
  • method Constructor
  • property CopyPicture as Boolean
  • property CopyMerge as Boolean
  • property CopyNamedRanges as Boolean
  • property CopyPrintArea as Boolean
  • property CopyPrintFit as Boolean
  • property CopyPrintRepeat as Boolean
  • property CopyHorPageBreak as Boolean
  • property CopyComments as Boolean
  • property CopyFormat as Boolean
  • property CopyRowHidden as Boolean
  • property CopyColHidden as Boolean
• class XLCorePropertiesMBS
  • method RemoveAll
  • method Constructor
  • property Handle as Integer
  • property Book as XLBookMBS
  • property Subject as String
  • property Creator as String
  • property LastModifiedBy as String
  • property CreatedAsDouble as Double
  • property Created as String
  • property Title as String
  • property ModifiedAsDouble as Double
  • property Modified as String
  • property Tags as String
  • property Categories as String
  • property Comments as String
• class XLFilterColumnMBS
  • 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 SetCustomFilterEx(Op1 as Integer, Value1 as String, Op2 as Integer, Value2 as String, andOp as Boolean = false)
  • method SetCustomFilter(Op as Integer, Value as String)
  • method GetTop10(byref value as double, byref top as boolean, byref percent as boolean) as boolean
  • method SetTop10(value as double, top as boolean = true, percent as boolean = false)
  • method Clear
  • method AddFilter(Filter as String)
  • method Filter(index as integer) as String
  • method Constructor
  • property Handle as Integer
  • property Book as XLBookMBS
  • property FilterSize as Integer
  • property Index as Integer
  • property FilterType as Integer
• class XLFontMBS
  • method Constructor
  • method Operator_Compare(other as XLFontMBS) as Integer
  • property Handle as Integer
  • property Book as XLBookMBS
  • property Size as Integer
  • property Italic as Boolean
  • property StrikeOut as Boolean
  • property Underline as Integer
  • property Bold as Boolean
  • property Script as Integer
  • property Name as String
  • property ColorValue as Integer
  • property ColorRGB as Color
• class XLFormatMBS
  • method Operator_Compare(other as XLFontMBS) as Integer
  • method SetFont(font as XLFontMBS) as boolean
  • method SetBorderColor(ColorValue as integer)
  • method SetBorder(border as integer = 1)
  • method SetRotation(rotation as integer) as boolean
  • method Constructor
  • property Handle as Integer
  • property Book as XLBookMBS
  • property BorderDiagonalColor as Integer
  • property BorderDiagonalStyle as Integer
  • property BorderDiagonal as Integer
  • property PatternBackgroundColor as Integer
  • property PatternForegroundColor as Integer
  • property FillPattern as Integer
  • property Font as XLFontMBS
  • property BorderLeftColor as Integer
  • property BorderRightColor as Integer
  • property BorderTopColor as Integer
  • property BorderBottomColor as Integer
  • property BorderLeft as Integer
  • property BorderRight as Integer
  • property BorderTop as Integer
  • property BorderBottom as Integer
  • property Rotation as Integer
  • property Hidden as Boolean
  • property Locked as Boolean
  • property ShrinkToFit as Boolean
  • property Indent as Integer
  • property Wrap as Boolean
  • property AlignH as Integer
  • property AlignV as Integer
  • property NumFormat as Integer
• class XLFormControlMBS
  • method Constructor
  • method Item(Index as Integer) as String
  • method AddItem(value as String)
  • method InsertItem(Index as Integer, value as String)
  • method ClearItems
  • method FromAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
  • method ToAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
  • property Handle as Integer
  • property Book as XLBookMBS
  • property ObjectType as Integer
  • property Checked as Integer
  • property FmlaGroup as String
  • property FmlaLink as String
  • property FmlaRange as String
  • property FmlaTxbx as String
  • property Name as String
  • property LinkedCell as String
  • property ListFillRange as String
  • property Macro as String
  • property AltText as String
  • property Locked as Boolean
  • property DefaultSize as Boolean
  • property Print as Boolean
  • property Disabled as Boolean
  • property ItemCount as Integer
  • property DropLines as Integer
  • property Dx as Integer
  • property FirstButton as Boolean
  • property Horiz as Integer
  • property Inc as Integer
  • property Max as Integer
  • property Min as Integer
  • property MultiSel as String
  • property Sel as Integer
• class XLRichStringMBS
  • method Text(Index as Integer) as String
  • method Text(Index as Integer, byref font as XLFontMBS) as String
  • method AddText(text as String, font as XLFontMBS = nil)
  • method AddFont(templateFont as XLFontMBS = nil) as XLFontMBS
  • method Constructor(book as XLBookMBS)
  • method AddStyledText(StyledText as StyledText)
  • property Handle as Integer
  • property Book as XLBookMBS
  • property TextCount as Integer
  • property Text as String
  • property StyledText as StyledText
• class XLSheetMBS
  • method ColFormat(col as integer) as XLFormatMBS
  • method RowFormat(row as integer) as XLFormatMBS
  • method AddConditionalFormatting as XLConditionalFormattingMBS
  • method HyperlinkIndex(row as integer, col as integer) as Integer
  • method SelectionRange as string
  • method AddSelectionRange(sqref as string)
  • method RemoveSelection
  • method SetActiveCell(row as integer, col as integer)
  • method GetActiveCell(byref row as integer, byref col as integer) as boolean
  • method FormControl(index as integer) as XLFormControlMBS
  • method RemoveRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean
  • method RemoveColAndKeepRanges(colFirst as integer, colLast as integer) as boolean
  • method InsertRowAndKeepRanges(rowFirst as integer, rowLast as integer) as boolean
  • method InsertColAndKeepRanges(colFirst as integer, colLast as integer) as boolean
  • method RemovePicture(row as integer, col as integer) as Boolean
  • method RemovePictureByIndex(index as integer) as Boolean
  • method ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS
  • method ReadRichString(row as integer, col as integer) as XLRichStringMBS
  • 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 WriteRichString(row as integer, col as integer, RichString as XLRichStringMBS, format as XLFormatMBS = nil) as boolean
  • method WriteStyledText(row as integer, col as integer, StyledText as StyledText, format as XLFormatMBS = nil) as boolean
  • method IsRichString(row as integer, col as integer) as Boolean
  • method ColWidthPx(col as integer) as Integer
  • method RowHeightPx(row as integer) as Integer
  • 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 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 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 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 RemoveDataValidations
  • method CopySheet(dest as XLBookMBS, Options as XLCopyOptionsMBS = nil)
  • method CopySheet(dest as XLSheetMBS, Options as XLCopyOptionsMBS = nil)
  • method CopyRow(dest as XLSheetMBS, SourceRow as Integer, DestRow as Integer, Options as XLCopyOptionsMBS = nil)
  • method CopyColumn(dest as XLSheetMBS, SourceColumn as Integer, DestColumn as Integer, Options as XLCopyOptionsMBS = nil)
  • method CopyCellValue(dest as XLSheetMBS, SourceRow as Integer, DestRow as Integer, SourceColumn as Integer, DestColumn as Integer, Options as XLCopyOptionsMBS = nil)
  • method ApplyFilter
  • method RemoveFilter
  • method AddIgnoredError(rowFirst as integer, colFirst as integer, rowLast as integer, colLast as integer, iError as Integer) as Boolean
  • method SetProtectEx(protect as boolean = true, password as string = "", enhancedProtection as integer = -1)
  • method SetTabRgbColor(red as Integer, green as Integer, blue as Integer)
  • method GetTabRgbColor(byref red as Integer, byref green as Integer, byref blue as Integer) as Boolean
  • method SetTabColor(colorValue as Integer)
  • 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 WriteError(row as integer, col as integer, Error as Integer, format as XLFormatMBS = nil)
  • method RemoveComment(row as integer, col as integer)
  • method WriteFormulaString(row as integer, col as integer, Expression as string, 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 GetPrintRepeatRows(byref rowFirst as integer, byref rowLast as integer) as boolean
  • method GetPrintRepeatCols(byref colFirst as integer, byref colLast as integer) as boolean
  • method GetPrintArea(byref rowFirst as integer, byref colFirst as integer, byref rowLast as integer, byref colLast as integer) as boolean
  • method SetAutoFitArea(rowFirst as integer = 0, colFirst as integer = 0, rowLast as integer = -1, colLast as integer = -1)
  • method ReadDate(row as integer, col as integer, byref format as XLFormatMBS) as date
  • method ReadDate(row as integer, col as integer) as date
  • method WriteDate(row as integer, col as integer, value as date, format as XLFormatMBS = nil) as boolean
  • method AddHyperlink(hyperlink as string, rowFirst as integer, rowLast as integer, colFirst as integer, colLast as integer)
  • method Hyperlink(index as Integer, byref rowFirst as integer, byref rowLast as integer, byref colFirst as integer, byref colLast as integer) as String
  • method DelHyperlink(index 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 SplitInfo(byref row as integer, byref col as integer) as Boolean
  • method DelMergeByIndex(index 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 RowColToAddr(row as integer, col as integer, rowRelative as boolean = true, colRelative as boolean = true) as string
  • method GetTopLeftView(byref row as integer, byref col as integer)
  • method SetTopLeftView(row as integer, col as integer)
  • 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 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 SetMerge(rowFirst as integer, rowLast as integer, colFirst as integer, colLast as integer) as boolean
  • method DelMerge(row as integer, col as integer) 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 SetRow(row as integer, height as double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
  • method SetCol(colFirst as integer, colLast as integer, width 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 SetColPx(colFirst as integer, colLast as integer, width as integer, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
  • 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 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 GetNamedRange(name as string, byref rowFirst as integer, byref rowLast as integer, byref colFirst as integer, byref 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 DelNamedRange(name as string, scopeId as integer = -2) 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 SetPrintRepeatRows(rowFirst as integer, rowLast as integer)
  • method SetPrintRepeatCols(colFirst as integer, colLast as integer)
  • method SetPrintArea(rowFirst as integer, rowLast as integer, colFirst as integer, colLast as integer)
  • method SetPrintFit(wPages as integer, hPages as integer)
  • method GetPrintFit(byref wPages as integer, byref hPages as integer) as boolean
  • method RemoveRow(rowFirst as integer, rowLast as integer) as boolean
  • method RemoveCol(colFirst as integer, colLast as integer) as boolean
  • method InsertRow(rowFirst as integer, rowLast as integer) as boolean
  • method InsertCol(colFirst as integer, colLast as integer) as boolean
  • method CopyCell(rowSrc as integer, colSrc as integer, rowDst as integer, colDst as integer) as boolean
  • method WriteComment(row as integer, col as integer, value as string, author as string, width as integer, height as integer)
  • method ReadComment(row as integer, col as integer) as string
  • method ReadFormula(row as integer, col as integer, byref format as XLFormatMBS) as string
  • method ReadFormula(row as integer, col as integer) as string
  • method WriteFormula(row as integer, col as integer, value as string, format as XLFormatMBS = nil) as boolean
  • method ReadBlank(row as integer, col as integer, byref format as XLFormatMBS) as boolean
  • method ReadBlank(row as integer, col as integer) as boolean
  • method WriteBlank(row as integer, col as integer, format as XLFormatMBS = nil) as boolean
  • method ReadBoolean(row as integer, col as integer, byref format as XLFormatMBS) as boolean
  • method ReadBoolean(row as integer, col as integer) as boolean
  • method WriteBoolean(row as integer, col as integer, value as boolean, format as XLFormatMBS = nil) as boolean
  • method ReadNumber(row as integer, col as integer, byref format as XLFormatMBS) as double
  • method ReadNumber(row as integer, col as integer) as double
  • method WriteNumber(row as integer, col as integer, value as double, format as XLFormatMBS = nil) as boolean
  • method ReadString(row as integer, col as integer, byref format as XLFormatMBS) as string
  • method ReadString(row as integer, col as integer) as string
  • 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 ReadValue(row as integer, col as integer, byref format as XLFormatMBS) as Variant
  • method ReadValue(row as integer, col as integer) as Variant
  • method RowHeight(row as integer) as double
  • method ColWidth(col as integer) as double
  • method SetFooter(footer as string, margin as double) as boolean
  • method SetHeader(header as string, margin as double) as boolean
  • method Split(row as integer, col as integer)
  • method SetVerPageBreak(row as integer, pageBreak as boolean = true) as boolean
  • method SetHorPageBreak(row as integer, pageBreak as boolean = true) as boolean
  • method GetVerPageBreak(index as integer) as integer
  • method GetHorPageBreak(index as integer) as integer
  • method ClearPrintRepeats
  • method ClearPrintArea
  • method Clear(rowFirst as integer = 0, rowLast as integer = 1048575, colFirst as integer = 0, colLast as integer = 16383) as Boolean
  • method ReadError(row as integer, col as integer) as integer
  • method IsDate(row as integer, col as integer) as boolean
  • method IsFormula(row as integer, col as integer) as boolean
  • method CellType(row as integer, col as integer) as integer
  • method Constructor
  • method IsAutoFilter as boolean
  • method ReadDateTime(row as integer, col as integer, byref format as XLFormatMBS) as dateTime
  • method ReadDateTime(row as integer, col as integer) as dateTime
  • method WriteDateTime(row as integer, col as integer, value as dateTime, format as XLFormatMBS = nil) as boolean
  • property RowHidden(row as integer) as boolean
  • property ColHidden(col as integer) as boolean
  • property CellFormat(row as integer, col as integer) as XLFormatMBS
  • property Handle as Integer
  • property Book as XLBookMBS
  • property PictureCount as Integer
  • property FormControlCount as Integer
  • property TableSize as Integer
  • property FirstRow as Integer
  • property LastRow as Integer
  • property FirstCol as Integer
  • property LastCol as Integer
  • property GroupSummaryRight as Boolean
  • property GroupSummaryBelow as Boolean
  • property RightToLeft as Boolean
  • property PrintRowCol as Boolean
  • property VCenter as Boolean
  • property HCenter as Boolean
  • property DisplayGridlines as Boolean
  • property PrintGridlines as Boolean
  • property MarginLeft as Double
  • property MarginRight as Double
  • property MarginTop as Double
  • property MarginBottom as Double
  • property Paper as Integer
  • property Landscape as Boolean
  • property PrintZoom as Integer
  • property Zoom as Integer
  • property Name as String
  • property Protect as Boolean
  • property Hidden as Integer
  • property AutoFilter as XLAutoFilterMBS
  • property HyperlinkSize as Integer
  • property MergeSize as Integer
  • property Footer as String
  • property Header as String
  • property FooterMargin as Double
  • property HeaderMargin as Double
  • property GetVerPageBreakCount as Integer
  • property GetHorPageBreakCount as Integer
  • property NamedRangeCount as Integer
  • property FirstFilledRow as Integer
  • property LastFilledRow as Integer
  • property FirstFilledCol as Integer
  • property LastFilledCol as Integer
  • property DefaultRowHeight as Double
  • property TabColor as Integer