HotXLS helpinhoud

Cells and Ranges

Components reference

TGridToXLS
- Properties
- Methods
- Events
TDataToXLS
- Properties
- Methods
- Events

Classes reference

IXLSWorkbook
- Properties
- Methods
IXLSWorksheet
- Properties
  - Cells
  - Selection
  - PageSetup
  - Range
  - RCRange
  - UsedRange
  - Name
  - Names
  - Index
  - Next
  - Previous
  - HPageBreaks
  - VPageBreaks
  - DisplayGridLines
  - DisplayZeros
  - DisplayRightToLeft
  - ScrollRow
  - ScrollColumn
  - Zoom
  - View
  - Selected
  - StandardHeight
  - StandardWidth
  - Hyperlinks
  - Shapes
  - Visible
  - Outline
  - IsProtected
  - Protection permissions
  - AutoFilterRange
  - Tables
  - TabColor
- Methods
IXLSWorksheets
- Properties
  - Entries
  - Count
- Methods
IXLSRange
- Properties
  - Borders
  - Cells
  - Column
  - Columns
  - ColumnWidth
  - Width
  - WidthInPixels
  - Comment
  - Count
  - EntireColumn
  - EntireRow
  - Font
  - Formula
  - FormulaHidden
  - HasFormula
  - Hidden
  - HorizontalAlignment
  - Hyperlinks
  - IndentLevel
  - Interior
  - Item
  - Locked
  - NumberFormat
  - MergeArea
  - MergeCells
  - Offset
  - Orientation
  - OutlineLevel
  - ReadingOrder
  - Row
  - RowHeight
  - Rows
  - ShrinkToFit
  - Value
  - VerticalAlignment
  - Worksheet
  - WrapText
- Methods
  - AddComment
  - AutoFit
  - Autofilter
  - Clear
  - ClearContents
  - ClearComments
  - ClearOutline
  - Copy
  - Delete
  - Group
  - Insert
  - Merge
  - Move
  - SaveAs
  - SaveAsCSV
  - SaveAsHTML
  - Select
  - UnGroup
  - Unmerge
IXLSPageSetup
- Properties
IXLSInterior
- Properties
- Methods
  - SetThemeColor
  - SetPatternThemeColor
IXLSBorder
- Properties
  - Color
  - ColorIndex
  - LineStyle
  - Weight
- Methods
  - SetThemeColor
IXLSBorders
- Properties
  - Color
  - ColorIndex
  - LineStyle
  - Weight
  - Item
IXLSFont
- Properties
  - Name
  - Size
  - ColorIndex
  - Color
  - Bold
  - Italic
  - Strikethrough
  - OutLineFont
  - Shadow
  - Underline
  - SubScript
  - SuperScript
- Methods
  - SetThemeColor
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
TXLSTextBox
- Properties
  - Text
  - TextRuns
  - Row1
  - Col1
  - Row2
  - Col2
- Methods
  - SetArea
TXLSOfficeArtOptions
- Members
  - IsDefined / LongValue / WideStringValue / Delete
TXLSShapes
- Properties
  - Count
  - Items
- Methods
TXLSColorFormat
- Properties
  - RGB
  - SchemeColor
- Free helpers (lxHandle unit)
  - XlsApplyThemeColorToDrawing — assign a workbook theme idx + tint to a drawing color slot (shapes, chart fills).
  - XlsGetDrawingThemeColor — recover the theme idx + tint last assigned to a drawing color slot within the same process (since v2.64.0).
TXLSFillFormat
- Properties
  - ForeColor
  - Visible
- Methods
  - Solid
TXLSLineFormat
- Properties
  - Style
  - DashStyle
  - ForeColor
  - Visible
  - Weight
IXLSHyperLinks
- Properties
  - Count
  - Item
- Methods
  - Add
  - Delete
IXLSHyperLink
- Properties
  - Address
  - Range
  - ScreenTip
  - SubAddress
  - TextToDisplay
- Methods
  - Delete
IXLSName
- Properties
  - Name
  - RefersTo
  - RefersToRange
  - Visible
  - Index
- Methods
  - Delete
IXLSNames
- Properties
  - Item
  - Count
- Methods
  - Add
TXLSOutline
- Properties
  - SummaryColumn
  - SummaryRow
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
TCondFormat / TCondFormatRule
- Enumerations
  - TXLSCfValueKind / TXLSIconSetType
- Spec classes
  - TXLSCfValue / TXLSDataBarSpec / TXLSColorScaleSpec / TXLSIconSetSpec
- TCondFormatRule properties
  - Kind / cfType / Operator_ / DataBar / ColorScale / IconSet / Style / DxfBlob
- TCondFormat members
  - ClearRow / ClearCol / ClearRange / MoveRanges / Range / IsEmpty / IsExt12
TXLSDxfStyle
- Setters
  - SetFontColor / SetFontColorTheme / SetFillBgColor / SetFillBgColorTheme / SetFillFgColor / SetFillFgColorTheme / SetFillPattern / SetFontBold / SetFontItalic / SetFontUnderline / SetNumFormatId
- Properties (per slot)
  - HasXxx / XxxColor / XxxColorIsTheme / XxxColorThemeId / XxxColorThemeTint
TXLSHTMLExport
- Properties
  - Options / Title / SimpleExport / TableBorderWidth / CellPadding / CellSpacing
- Methods
  - SaveAsHTML overloads for workbook, worksheet, range, file, and stream output

XLSX facade (lxHandleX)

Overview and quick start
TXLSXWorkbook
- Methods
  - SaveAs / Open
- Properties
  - Sheets / Fonts / Fills / Borders / NumberFormats / DefinedNames
TXLSXSheets
- Methods
  - Add / Clear / IndexByName / SheetByName / TryGetSheetByName
- Properties
  - Count / Items
TXLSXFont / TXLSXFonts
- TXLSXFont properties
  - Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto
- TXLSXFonts members
  - Add (3 overloads) / Clear / Count / Items
TXLSXFill / TXLSXFills
- TXLSXFill properties
  - Pattern / ForegroundColor / ForegroundIsAuto / BackgroundColor / BackgroundIsAuto
- TXLSXFills members
  - Add / AddSolid / Clear / Count / Items
TXLSXBorder / TXLSXBorders
- TXLSXBorder properties
  - Left / Right / Top / Bottom / Diagonal (each = Style + Color + ColorIsAuto)
- TXLSXBorders members
  - Add / AddBox / Clear / Count / Items
TXLSXNumberFormat / TXLSXNumberFormats
- Members
  - FormatCode / Add / IndexOf / Clear / Count / Items
TXLSXDefinedName / TXLSXDefinedNames
- TXLSXDefinedName properties
  - Name / Formula / SheetIndex / Hidden / Comment
- TXLSXDefinedNames members
  - Add (2 overloads) / IndexOfName / Clear / Count / Items
TXLSXExternalLink / TXLSXExternalLinks
- TXLSXExternalLink properties
  - Target / SheetNames
- TXLSXExternalLinks members
  - Add / Clear / Count / Items
TXLSXWorksheet
- Methods
  - Calculate / MergeCells / ForEachCell / FindText / ReplaceText / WriteCells / AddHyperlink / AddComment / AddImage / AddImageFromFile / AddConditionalFormat / AddDataValidation / AddListValidation / AutoFitColumn / AutoFitColumns / AutoFitRow / AutoFitRows / InsertRows / DeleteRows / InsertCols / DeleteCols / AddRowBreak / AddColBreak / ClearRowBreaks / ClearColBreaks / SetAutoFilter / AddAutoFilterColumn / SetColWidth / SetRowHeight
- Properties
  - Name / Visibility / IsSelected / Zoom / DisplayGridLines / DisplayZeros / DisplayRightToLeft / StandardWidth / StandardHeight / Cells / Range / RCRange / UsedRange / MergedCells / Hyperlinks / Comments / Images / ConditionalFormats / DataValidations / Tables / Charts / AutoFilterRange / AutoFilterColumns / PrintArea / PrintTitleRows / PrintTitleCols / BlackAndWhite / Draft / PrintNotes / PrintOverThenDown / ColWidth / RowHeight
TXLSXRange
- Members
  - RefA1 / SaveAsHTML / SetValue / SetFormula / Clear / ClearAll / SetNumberFormat / SetBorders / AutoFitColumns / AutoFitRows / Merge / Unmerge / Offset / Resize
TXLSXCells / TXLSXCell
- TXLSXCell properties
  - Row / Col / Value / FormatIndex / FontIndex / FillIndex / BorderIndex / NumberFormatIndex / AlignmentIndex / Formula / RichText / Locked / FormulaHidden
- TXLSXCells members
  - 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 / Author / Text
- TXLSXComments members
  - Add (2 overloads) / Clear / Count / Items
TXLSXImage / TXLSXImages
- TXLSXImage properties
  - Row / Col / WidthEMU / HeightEMU / Format / Data
- TXLSXImages members
  - Add / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- TXLSXConditionalFormat properties
  - Range / Op / Formula1 / Formula2
- TXLSXConditionalFormats members
  - Add (2 overloads) / Clear / Count / Items
TXLSXDataValidation / TXLSXDataValidations
- TXLSXDataValidation properties
  - Range / ValidationType / Op / Formula1 / Formula2 / AllowBlank / ShowInputMessage / ShowErrorMessage
- 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 / Title / CategoryAxisTitle / ValueAxisTitle / FromRow / FromCol / ToRow / ToCol / AddSeries / ClearSeries / SeriesCount / Series / Add / Clear / Count / Items
TXLSXRichText
- Members
  - AddRun / Clear / RunCount / PlainText / Items
TXLSXAlignment / TXLSXAlignments
- Members
  - Horizontal / Vertical / WrapText / ShrinkToFit / TextRotation / Indent / Add / Clear / Count / Items

Overview

Cells and Ranges

Components reference

Classes reference

XLSX facade (lxHandleX)

Examples