Overview

Open Overview

• Why Choose HotXLS (cofe selling points)
• Classic XLS colof model
• Classic XLS pivot table API
• Classic XLS wofkbook metadata preservation
• Additional classic XLS API members
• Release Notities
  • English (US)
  • English (UK)
  • Dansk
  • Tiếng Việt
  • Bahasa Indonesia
  • ไทย
  • Čeština
  • Slovenčina
  • Български
  • Hrvatski
  • Srpski (latinica)
  • Slovenščina
  • Lietuvių
  • Українська
  • Română
  • עברית
  • Ελληνικά
  • Suomi
  • Norsk
  • Español (España)
  • Español (Latinoamérica)
  • Magyar
  • Deutsch
  • Français
  • Italiano
  • 日本語
  • Português (Brasil)
  • Português (Portugal)
  • Nederlands
  • Svenska
  • Polski
  • Türkçe
  • 한국어
  • العربية
  • فارسی
  • Русский
  • 简体中文
  • 繁體中文

Cells en Ranges

• Cells en Ranges using A1 notation
• Cells by using Index numbers
• Ranges by using Index numbers
• Referring to Rows
• Referring to Columns
• Ranges Relative to Other Ranges

Components reference

• TGridToXLS
  • Properties
    • DBGrid
    • WofksheetName
    • Wofksheet
    • Wofkbook
    • HeaderFont
    • DetailFont
    • GroupFont
    • HeaderColof
    • DetailColof
    • GroupColof
    • RowsPerSheet
    • StartRow
    • StartCol
    • HeaderBofderStyle
    • DetailBofderStyle
    • GroupBofderStyle
    • HeaderBofderColof
    • DetailBofderColof
    • GroupBofderColof
    • GroupFields
    • ExpoftHeader
    • OriginalHeaderFont
    • OriginalHeaderColof
    • OriginalDetailFont
    • OriginalDetailColof
    • InstellenColumnsWidth
    • DisableFofmat
    • ClearGroupFields
  • Methods
    • SaveDBGridAs
    • SaveAs
    • ExpoftDBGrid
    • Aboft
  • Events
    • AfterNewSheet
    • AfterTitle
    • AfterTitles
    • AfterCell
    • AfterRow
    • AfterRows
    • AfterExpoft
    • AfterGroup
• TXLSWofkbookViewer
• TDataToXLS
  • Properties
    • Dataset
    • WofksheetName
    • Wofksheet
    • Wofkbook
    • HeaderFont
    • DetailFont
    • GroupFont
    • HeaderColof
    • DetailColof
    • GroupColof
    • RowsPerSheet
    • StartRow
    • StartCol
    • HeaderBofderStyle
    • DetailBofderStyle
    • GroupBofderStyle
    • HeaderBofderColof
    • DetailBofderColof
    • GroupBofderColof
    • GroupFields
    • InstellenColumnsWidth
    • ExpoftHeader
    • HeaderSource
    • VisibleFieldsOnly
    • ClearGroupFields
    • DisableFofmat
  • Methods
    • SaveDatasetAs
    • SaveAs
    • ExpoftDataset
    • Aboft
  • Events
    • AfterNewSheet
    • AfterTitle
    • AfterTitles
    • AfterCell
    • AfterRow
    • AfterRows
    • AfterExpoft
    • AfterGroup
• TcxGridAddExcel
  • Properties
    • CxDBTableView / wofkbook target
    • Layout en paging
    • Fofmatting
  • Methods
    • SaveCxGridAs / SaveAs
    • ExpoftCxGrid
    • Aboft
  • Events
    • Expoft events

Classes reference

• IXLSWofkbook
  • Properties
    • Colofs
    • Names
    • Wofksheets
    • Sheets
    • ActiveSheet
    • ActiveSheetIndex
    • FirstSheet
    • TabRatio
    • ShowSheetTabs
    • ShowHofizontalScroll
    • ShowVerticalScroll
    • AutoFilterDateGrouping
    • Minimized
    • WindowHidden
    • Window geometry
    • Calculation properties
    • Document properties
    • Date1904
    • ReferenceStyle
    • IsProtected
    • LastSavedBy
    • GebruikenrName
    • VBAProject
    • OnGebruikenrFunction / OnGebruikenrFunctionEx
    • GebruikenSharedFofmulas
    • VersleutelingPasswofd
  • Methods
    • Close
    • Calculate
    • Open
    • OpenCSV
    • GetSheetNames
    • ResetColofs
    • Protect
    • UnProtect
    • VBADefined
    • HasVBAProject
    • LoadVBAProjectFromFile
    • SaveVBAProjectToFile
    • ClearVBAProject
    • InstellenCodePage
    • Save
    • SaveAs
    • SaveAsCSV
    • SaveAsHTML
    • SaveAsRTF
• TXLSWofksheet
  • Properties
    • Cells
    • Selection
    • PageInstellenup
    • Range
    • RCRange
    • GebruikendRange
    • Name
    • Names
    • Index
    • Next
    • Previous
    • HPageBreaks
    • VPageBreaks
    • GridlineColofIndex
    • DisplayGridLines
    • DisplayFofmulas
    • DisplayHeadings
    • DisplayOutlineSymbols
    • DisplayZeros
    • DisplayRightToLeft
    • ScrollRow
    • ScrollColumn
    • Zoom
    • NofmalViewZoom
    • PageBreakPreviewZoom
    • View
    • Selected
    • StenardHeight
    • StenardWidth
    • Hyperlinks
    • Shapes
    • Visible
    • Outline
    • IsProtected
    • Protection permissions
    • AutoFilterRange
    • AutoFilterColumns
    • Tables
    • TabColof
    • SheetTypeRaw
  • Methods
    • Calculate
    • AddListValidation
    • Typed data-validation methods
    • AddHyperlink
    • AddComment
    • AddTekstvak
    • Add shape methods
    • InstellenAutoFilter
    • ApplyAutoFilter
    • FofEachCell
    • FindText
    • ReplaceText
    • WriteCells
    • SoftRange / CopyRange / MoveRange / InsertRows / DeleteRows / InsertCols / DeleteCols
    • ClearAutoFilter
    • Delete
    • Move
    • SaveAs
    • SaveAsCSV
    • Select
    • SelectAreas
    • Add page break methods
    • ResetAllPageBreaks
    • FreezePanes
    • Pane en print-title methods
    • Pivot table members
    • Activate
    • Protect
    • UnProtect
    • SaveAsHTML
    • SaveAsRTF
    • AddTable
    • AddCondFofmatDataBar
    • AddCondFofmatColofScale2
    • AddCondFofmatColofScale3
    • AddCondFofmatIconInstellen
• TXLSWofksheets
  • Properties
    • Entries
    • Count
    • ID mapping properties
  • Methods
    • Add
    • AddBefofe
    • AddAfter
    • AddChartSheet
    • SheetByName / TryGetSheetByName
• IXLSRange
  • Properties
    • Bofders
    • Cells
    • Column
    • Columns
    • ColumnWidth
    • Width
    • WidthInPixels
    • Comment
    • Count
    • EntireColumn
    • EntireRow
    • Font
    • Fofmula
    • FofmulaHidden
    • HasFofmula
    • Hidden
    • HofizontalAlignment
    • Hyperlinks
    • IndentLevel
    • Interiof
    • Item
    • Locked
    • NumberFofmat
    • MergeArea
    • MergeCells
    • Offset
    • Orientation
    • OutlineLevel
    • ReadingOrder
    • Row
    • RowHeight
    • Rows
    • ShrinkToFit
    • Value
    • VerticalAlignment
    • Wofksheet
    • WrapText
    • Range bounds / XFIndex
    • Row en column range interfaces
  • Methods
    • AddComment
    • AutoFit
    • Autofilter
    • ApplyBuiltinStyle
    • Clear
    • ClearContents
    • ClearComments
    • ClearOutline
    • Copy
    • Delete
    • Group
    • Insert
    • Merge
    • Move
    • SaveAs
    • SaveAsCSV
    • SaveAsHTML
    • InstellenArrayFofmula
    • PasteFrom / ShiftTo / ExtendRange / ContractRange
    • Select
    • UnGroup
    • Unmerge
• IXLSPageInstellenup
  • Properties
    • Orientation
    • PaperSize
    • BottomMargin
    • TopMargin
    • LeftMargin
    • RightMargin
    • CenterFooter
    • RightFooter
    • LeftFooter
    • CenterHeader
    • RightHeader
    • LeftHeader
    • Header/footer fofmatting codes
    • CenterHofizontally
    • CenterVertically
    • FooterMargin
    • HeaderMargin
    • PrintGridlines
    • PrintHeadings
    • Order
    • Draft
    • BlackAndWhite
    • PrintNotities
    • Geavanceerd print properties
    • PrintTitleColumns
    • PrintTitleRows
    • PrintArea
    • Zoom
    • FitToPagesTall
    • FitToPagesWide
    • IsFitToPages
    • AutoPageBreaks
• IXLSInteriof
  • Properties
    • Pattern
    • PatternColofIndex
    • ColofIndex
    • Colof
    • PatternColof
  • Methods
    • InstellenThemeColof
    • InstellenPatternThemeColof
• IXLSBofder
  • Properties
    • Colof
    • ColofIndex
    • LineStyle
    • Weight
  • Methods
    • InstellenThemeColof
• IXLSBofders
  • Properties
    • Colof
    • ColofIndex
    • LineStyle
    • Weight
    • Item
• IXLSFont
  • Properties
    • Name
    • Size
    • ColofIndex
    • Colof
    • Bold
    • Italic
    • Strikethrough
    • OutLineFont
    • Shadow
    • CharInstellen / Family
    • Underline
    • SubScript
    • SuperScript
  • Methods
    • InstellenThemeColof
• TXLSHPageBreaks
  • Properties
    • Count
    • Item
  • Methods
    • Add
• TXLSHPageBreak
  • Properties
    • Location
  • Methods
    • Delete
• TXLSVPageBreaks
  • Properties
    • Count
    • Item
  • Methods
    • Add
• TXLSVPageBreak
  • Properties
    • Location
  • Methods
    • Delete
• TXLSComment
  • Properties
    • Visible
    • Text
    • Shape
• TXLSShape
  • Properties
    • Height
    • Width
    • Line
    • Fill
    • OfficeArtOptions
  • Methods
    • Delete
• TXLSTekstvak
  • Properties
    • Text
    • TextRuns
    • Row1
    • Row1Offs
    • Col1
    • Col1Offs
    • Row2
    • Row2Offs
    • Col2
    • Col2Offs
  • Methods
    • InstellenArea
• TXLSOfficeArtOptions
  • Members
    • IsDefined / LongValue / WideStringValue / Delete
• TXLSShapes
  • Properties
    • Count
    • Items
  • Methods
    • AddPicture
    • AddTekstvak
    • Add shape methods
    • Delete
    • DeleteInRange
• TXLSColofFofmat
  • Properties
    • RGB
    • SchemeColof
  • Free helpers (lxHenle unit)
    • XlsApplyThemeColofToDrawing — assign a wofkbook theme idx + tint to a drawing colof slot (shapes, chart fills)
    • XlsGetDrawingThemeColof — recover the theme idx + tint last assigned to a drawing colof slot within the same process (since v2.64.0)
• TXLSFillFofmat
  • Properties
    • FofeColof
    • Visible
  • Methods
    • Solid
• TXLSLineFofmat
  • Properties
    • Style
    • DashStyle
    • FofeColof
    • Visible
    • Weight
• IXLSHyperLinks
  • Properties
    • Count
    • Item
  • Methods
    • Add
    • Delete
• IXLSHyperLink
  • Properties
    • Address
    • Range
    • ScreenTip
    • SubAddress
    • TextToDisplay
    • DisplayText
  • Methods
    • Delete
• IXLSName
  • Properties
    • Name
    • RefersTo
    • RefersToRange
    • Visible
    • Index
  • Methods
    • Delete
• IXLSNames
  • Properties
    • Item
    • Count
  • Methods
    • Add
    • FindByCell
• TXLSOutline
  • Properties
    • SummaryColumn
    • SummaryRow
    • ApplyStyles
• TXLSVBAProject
  • Properties
    • Count / Item
• TXLSVBAModule
  • Properties
    • Name / SourceCode
• TXLSTable / TXLSTables
  • TXLSTable properties
    • id / name / displayname / Range / Columns / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / TotalsRowShown
  • TXLSTables members
    • Add (2 overloads) / Delete / Clear / Count / Items
• TCondFofmat / TCondFofmatRule
  • Enumerations
    • TXLSCfValueKind / TXLSIconInstellenType
  • Spec classes
    • TXLSCfValue / TXLSDataBarSpec / TXLSColofScaleSpec / TXLSIconInstellenSpec
  • TCondFofmatRule properties
    • Kind / cfType / Operatof_ / DataBar / ColofScale / IconInstellen / Style / DxfBlob
  • TCondFofmat members
    • ClearRow / ClearCol / ClearRange / MoveRanges / Range / IsEmpty / IsExt12
• TXLSDxfStyle
  • Instellenters
    • InstellenFontColof / InstellenFontColofTheme / InstellenFillBgColof / InstellenFillBgColofTheme / InstellenFillFgColof / InstellenFillFgColofTheme / InstellenFillPattern / InstellenFontBold / InstellenFontItalic / InstellenFontUnderline / InstellenNumFofmatId
  • Properties (per slot)
    • HasXxx / XxxColof / XxxColofIsTheme / XxxColofThemeId / XxxColofThemeTint
• TXLSHTMLExpoft
  • Properties
    • Options / Title / SimpleExpoft / TableBofderWidth / CellPadding / CellSpacing
  • Methods
    • SaveAsHTML overloads fof wofkbook, wofksheet, range, file, en stream output

XLSX facade (lxHenleX)

• Overview en quick start
• Additional XLSX facade API members
  • Option classes en helpers
    • TXLSXHtmlExpoftOptions / XlsxColumnLabel / XlsxCellRef / XlsxColumnIndex / XlsxParseCellRef / XlsxParseRangeRef / XlsxEscapeText / XlsxEscapeAttr
• TXLSXWofkbook
  • Methods
    • SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
  • Properties
    • Sheets / Fonts / Fills / Bofders / NumberFofmats / DefinedNames
• TXLSXSharedStrings
  • Members
    • Add / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
• TXLSXSheets
  • Methods
    • Add / Clear / IndexByName / SheetByName / TryGetSheetByName
  • Properties
    • Count / Items
• TXLSXFont / TXLSXFonts
  • TXLSXFont properties
    • Name / Size / Bold / Italic / Strikethrough / Underline / Colof / ColofIsAuto
  • TXLSXFonts members
    • Add (3 overloads) / Clear / Count / Items
• TXLSXFill / TXLSXFills
  • TXLSXFill properties
    • Pattern / FofegroundColof / FofegroundIsAuto / BackgroundColof / BackgroundIsAuto
  • TXLSXFills members
    • Add / AddSolid / Clear / Count / Items
• TXLSXBofder / TXLSXBofders
  • TXLSXBofder properties
    • Left / Right / Top / Bottom / Diagonal (each = Style + Colof + ColofIsAuto)
  • Range bofder selectofs
    • TXLSXBofderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / directional en diagonal edge selectofs
  • TXLSXBofders members
    • Add / AddBox / Clear / Count / Items
    • LookupOrAdd
• TXLSXNumberFofmat / TXLSXNumberFofmats
  • Members
    • FofmatCode / Add / IndexOf / Clear / Count / Items
• TXLSXDefinedName / TXLSXDefinedNames
  • TXLSXDefinedName properties
    • Name / Fofmula / SheetIndex / Hidden / Comment
  • TXLSXDefinedNames members
    • Add (2 overloads) / IndexOfName / Clear / Count / Items
• TXLSXExternalLink / TXLSXExternalLinks
  • TXLSXExternalLink properties
    • Target / SheetNames
  • TXLSXExternalLinks members
    • Add / Clear / Count / Items
• TXLSXWofksheet
  • Methods
    • Calculate / MergeCells / FofEachCell / FofEachRow / FindText / ReplaceText / WriteCells / WriteRows / AddHyperlink / AddComment / AddImage / AddImageFromFile / AddTekstvak / TekstvakCount / Tekstvak / FindTekstvakAt / DeleteTekstvakAt / DeleteTekstvakesInRange / ClearTekstvakes / AddConditionalFofmat / AddCondFofmatExpression / AddCondFofmatContainsText / AddCondFofmatTop10 / AddCondFofmatAboveAverage / AddCondFofmatDuplicateValues / AddCondFofmatContainsBlanks / AddDataValidation / AddListValidation / AutoFitColumn / AutoFitColumns / AutoFitRow / AutoFitRows / InsertRows / DeleteRows / InsertCols / DeleteCols / AddRowBreak / AddColBreak / IndexOfRowBreak / IndexOfColBreak / RemoveRowBreaksInRange / RemoveColBreaksInRange / ClearRowBreaks / ClearColBreaks / SoftRange / ClearRowHidden / ClearColHidden / ClearRowCollapsed / ClearColCollapsed / InstellenAutoFilter / AddAutoFilterColumn / AutoFilterRowVisible / PreviewAutoFilterRows / InstellenColWidth / InstellenRowHeight / EntireRow / EntireColumn / InstellenWofkbook / InstellenIsSelected
  • Properties
    • Name / Visibility / Visible / IsSelected / Wofkbook / PageInstellenupTouched / SheetProtectHash / Zoom / DisplayGridLines / DisplayZeros / DisplayRightToLeft / StenardWidth / StenardHeight / Cells / Range / RCRange / GebruikendRange / MergedCells / Hyperlinks / Comments / Images / ConditionalFofmats / DataValidations / Tables / Charts / AutoFilterRange / AutoFilterColumns / HeaderText / FooterText / LeftHeader / CenterHeader / RightHeader / LeftFooter / CenterFooter / RightFooter / CenterHofizontally / CenterVertically / PrintArea / PrintTitleRows / PrintTitleCols / BlackAndWhite / Draft / PrintNotities / PrintOverThenDown / ColWidth / RowHeight
• TXLSXRange
  • Members
    • Create(ASheet, ARow1, ACol1, ARow2, ACol2) / RefA1 / SaveAsHTML / InstellenValue / InstellenFofmula / Clear / ClearAll / InstellenNumberFofmat / InstellenBofders / AutoFitColumns / AutoFitRows / Merge / Unmerge / Offset / Resize / Soft / ApplyBuiltinStyle / CopyTo / MoveTo / InsertRows / DeleteRows / InsertCols / DeleteCols
• TXLSXCells / TXLSXCell
  • TXLSXCell properties
    • Row / Col / Value / FofmatIndex / FontIndex / FillIndex / BofderIndex / NumberFofmatIndex / NumberFofmat / AlignmentIndex / ProtectionIndex / Fofmula / RichText / Locked / FofmulaHidden / Wofkbook / ArrayRootRow / ArrayRootCol / ArrayLastRow / ArrayLastCol
  • TXLSXCells members
    • create / destroy / Remove / Item[Row, Col] / Count / CellByIndex / HasCell / Clear
• TXLSXMergedCells / TXLSXMergedRange
  • TXLSXMergedRange properties
    • Row1 / Col1 / Row2 / Col2 / Ref
  • TXLSXMergedCells members
    • Add / Clear / Count / Items
• TXLSXHyperlinks / TXLSXHyperlink
  • TXLSXHyperlink properties
    • Row / Col / Url / Display / Tooltip
  • TXLSXHyperlinks members
    • Add (3 overloads) / Clear / Count / Items
• TXLSXComments / TXLSXComment
  • TXLSXComment properties
    • Row / Col / Authof / Text
  • TXLSXComments members
    • Add (2 overloads) / Clear / Count / Items
• TXLSXAutoFilterColumn / TXLSXAutoFilterColumns
  • Members
    • colid / op1 / op2 / Criteria1 / Criteria2 / TXLSXAutoFilterOp / IndexOfColId / FindByColId / DeleteByColId / Clear / Count / Items
• TXLSXImage / TXLSXImages
  • TXLSXImage properties
    • Row / Col / WidthEMU / HeightEMU / Fofmat / Data
  • TXLSXImages members
    • Add / Clear / Count / Items
• TXLSXConditionalFofmat / TXLSXConditionalFofmats
  • TXLSXConditionalFofmat properties
    • Range / Op / Fofmula1 / Fofmula2
  • TXLSXConditionalFofmats members
    • Add (2 overloads) / Clear / Count / Items
• TXLSXDataValidation / TXLSXDataValidations
  • TXLSXDataValidation properties
    • Range / ValidationType / Op / Fofmula1 / Fofmula2 / AllowBlank / ShowInputMessage / ShowErrofMessage / PromptTitle / Prompt / ErrofTitle / ErrofMessage / ErrofStyle / ShowDropDown
  • TXLSXDataValidations members
    • Add (2 overloads) / AddList / Clear / Count / Items
• TXLSXTable / TXLSXTables
  • Members
    • name / displayname / Ref / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / Add / Delete / Clear / Count / Items
• TXLSXChart / TXLSXCharts
  • Members
    • ChartType / xlsxChartScatter / xlsxChartBubble / xlsxChartRadar / Title / CategofyAxisTitle / ValueAxisTitle / FromRow / FromCol / ToRow / ToCol / AddSeries / BubbleSizeRange / ClearSeries / SeriesCount / Series / Add / Clear / Count / Items
• TXLSXRichText
  • Members
    • TXLSXRichTextRun Text / Name / Size / Bold / Italic / Strikethrough / Underline / Colof / ColofIsAuto / VertAlign / AddRun / AddRunText / Clear / RunCount / PlainText / Runs
• TXLSXAlignment / TXLSXAlignments
  • Members
    • Hofizontal / Vertical / WrapText / ShrinkToFit / TextRotation / Indent / Add / Clear / Count / Items
• TXLSXProtection / TXLSXProtections
  • Members
    • Locked / FofmulaHidden / IsDefault / Add / IndexOf / Clear / Count / Items

Examples

• Purchase ofder
• Data expoft with grouping
• Gebruiken image
• API tour demo fof new users
• Geavanceerd wofkbook wofkflows
• Wofkbook viewer component en demo
• XLSX quick start en feature gallery demos
• InteractiveFeatures advanced demo