Classes reference
- IXLSWorkbook
- TXLSWorksheet
- TXLSWorksheets
- IXLSRange
- IXLSPageSetup
- IXLSInterior
- IXLSBorder
- IXLSBorders
- IXLSFont
- TXLSHPageBreaks
- TXLSHPageBreak
- TXLSVPageBreaks
- TXLSVPageBreak
- TXLSComment
- TXLSFormatSnapshot
- TXLSShape
- TXLSTextBox
- TXLSOfficeArtOptions
- Members
- IsDefined / LongValue / WideStringValue / Delete
- TXLSShapes
- Classic form controls
- TXLSColorFormat
- Properties
- Free helpers (lxHandle unit)
- TXLSFillFormat
- TXLSLineFormat
- IXLSHyperLinks
- IXLSHyperLink
- IXLSName
- IXLSNames
- TXLSOutline
- TXLSVBAProject
- TXLSVBAModule
- 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
- Overview and quick start
- Compiled reporting API
- Workbook views, connections, and XML Maps
- Worksheet pane selections
- Formula tokens and user functions
- Advanced rendering and export
- Calculation and conversion fidelity
- XLSB values and styles
- Additional XLSX facade API members
- Option classes and helpers
- TXLSXHtmlExportOptions, XlsxColumnLabel, XlsxCellRef, XlsxColumnIndex, XlsxParseCellRef, XlsxParseRangeRef, XlsxEscapeText, XlsxEscapeAttr
- Advanced XLSX API members
- TXLSXWorkbook
- TXLSXSharedStrings
- Members
- Add / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
- TXLSXSheets
- Methods
- Add / Clear / IndexByName / SheetByName / TryGetSheetByName
- Properties
- TXLSXFont / TXLSXFonts
- TXLSXFont properties
- Name / Size / Bold / Italic / Strikethrough / Underline / colour / 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 + colour + ColorIsAuto)
- Range border selectors
- TXLSXBorderEdgeKind, xlsxEdgeAll, xlsxEdgeOutline, xlsxEdgeInside, plus the directional and diagonal edge selectors
- TXLSXBorders members
- Add / AddBox / Clear / Count / Items
- LookupOrAdd
- 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
- TXLSXExternalLinks members
- Add / Clear / Count / Items
- TXLSXWorksheet
- Methods
- Calculate / MergeCells / ForEachCell / ForEachRow / FindText / ReplaceText / WriteCells / WriteRows / AddHyperlink / AddComment / AddImage / AddImageFromFile / AddTextBox / TextBoxCount / TextBox / FindTextBoxAt / DeleteTextBoxAt / DeleteTextBoxesInRange / ClearTextBoxes / AddConditionalFormat / AddCondFormatExpression / AddCondFormatContainsText / AddCondFormatTop10 / AddCondFormatAboveAverage / AddCondFormatDuplicateValues / AddCondFormatContainsBlanks / AddDataValidation / AddListValidation / AutoFitColumn / AutoFitColumns / AutoFitRow / AutoFitRows / InsertRows / DeleteRows / InsertCols / DeleteCols / AddRowBreak / AddColBreak / IndexOfRowBreak / IndexOfColBreak / RemoveRowBreaksInRange / RemoveColBreaksInRange / ClearRowBreaks / ClearColBreaks / SortRange / ClearRowHidden / ClearColHidden / ClearRowCollapsed / ClearColCollapsed / SetAutoFilter / AddAutoFilterColumn / AutoFilterRowVisible / PreviewAutoFilterRows / SetColWidth / SetRowHeight / EntireRow / EntireColumn / SetWorkbook / SetIsSelected
- Properties
- Name / Visibility / Visible / IsSelected / Workbook / PageSetupTouched / SheetProtectHash / Zoom / DisplayGridLines / DisplayZeros / DisplayRightToLeft / StandardWidth / StandardHeight / Cells / Range / RCRange / UsedRange / MergedCells / Hyperlinks / Comments / Images / ConditionalFormats / DataValidations / Tables / Charts / AutoFilterRange / AutoFilterColumns / HeaderText / FooterText / LeftHeader / CenterHeader / RightHeader / LeftFooter / CenterFooter / RightFooter / CenterHorizontally / CenterVertically / PrintArea / PrintTitleRows / PrintTitleCols / BlackAndWhite / Draft / PrintNotes / PrintOverThenDown / ColWidth / RowHeight
- TXLSXStructuralEditRegistry
- Members
- RegisterParticipant / UnregisterParticipant / Clear / Count
- TXLSFormulaDebugger
- Members
- Analyze, Formula, FinalValue, Nodes, Dependencies, StepNodes, CurrentNode, MoveFirst, MoveNext, MovePrevious, SeekNode, Reset, ErrorOriginNodeId, ErrorCode, ErrorText
- TXLSPaginationModel
- Members
- Build, Clear, Count, Pages, RenderPage, CreatePageMetafile, SavePageAsMetafile, UseWorksheetPageSetup, Orientation, Margin, DefaultRowHeight
- TXLSXRange
- Members
- Create(ASheet, ARow1, ACol1, ARow2, ACol2), RefA1, SaveAsHTML, SetValue, SetFormula, Clear, ClearAll, SetNumberFormat, SetBorders, AutoFitColumns, AutoFitRows, Merge, Unmerge, Offset, Resize, Sort, ApplyBuiltinStyle, CopyTo, MoveTo, InsertRows, DeleteRows, InsertCols, DeleteCols
- TXLSXCells / TXLSXCell
- TXLSXCell properties
- Row, Col, Value, FormatIndex, FontIndex, FillIndex, BorderIndex, NumberFormatIndex, NumberFormat, AlignmentIndex, ProtectionIndex, Formula, RichText, Locked, FormulaHidden, Workbook, 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 / Author / 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 / Format / Data
- TXLSXImages members
- Add / Clear / Count / Items
- TXLSXHeaderFooterImage / TXLSXHeaderFooterImages
- Image properties
- PageKind, Position, WidthPt, HeightPt, MarginLeftPt, MarginTopPt, Format, Data, Title
- Collection members
- Add / AddFromFile / IndexOf / Find / Delete / Assign / 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, PromptTitle, Prompt, ErrorTitle, ErrorMessage, ErrorStyle, 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 / CategoryAxisTitle / ValueAxisTitle / FromRow / FromCol / ToRow / ToCol / AddSeries / BubbleSizeRange / ClearSeries / SeriesCount / Series / Add / Clear / Count / Items
- TXLSXChartTextStyle
- TXLSXChartLayout
- TXLSXRichText
- Members
- TXLSXRichTextRun Text / Name / Size / Bold / Italic / Strikethrough / Underline / colour / ColorIsAuto / VertAlign / AddRun / AddRunText / Clear / RunCount / PlainText / Runs
- TXLSXAlignment / TXLSXAlignments
- Members
- Horizontal, Vertical, WrapText, ShrinkToFit, TextRotation, Indent, Add, Clear, Count, Items
- TXLSXProtection / TXLSXProtections
- Members
- Locked / FormulaHidden / IsDefault / Add / IndexOf / Clear / Count / Items
- TXLSXNamedStyle / TXLSXNamedStyles
- Members
- Name, XfId, BuiltInId, CustomBuiltIn, Hidden, BuiltinLevel, Add, Clear, Count, Items
- TXLSXProtectedRange / TXLSXProtectedRanges
- Members
- Name / Sqref / Password / SecurityDescriptor / Add / Clear / Count / Items