Documentație HotXLS

Referința componentelor

TGridToXLS
- Proprietăți
- Metode
- Evenimente
TXLSWorkbookViewer
TDataToXLS
- Proprietăți
- Metode
- Evenimente
TcxGridAddExcel
- Proprietăți
- Metode
- Evenimente
  - Export events

Referința claselor

IXLSWorkbook
- Proprietăți
- Metode
TXLSWorksheet
- Proprietăți
  - Cells
  - Selection
  - PageSetup
  - Range
  - RCRange
  - UsedRange
  - Name
  - Names
  - Index
  - Next
  - Previous
  - HPageBreaks
  - VPageBreaks
  - GridlineColorIndex
  - DisplayGridLines
  - DisplayFormulas
  - DisplayHeadings
  - DisplayOutlineSymbols
  - DisplayZeros
  - DisplayRightToLeft
  - ScrollRow
  - ScrollColumn
  - Zoom
  - NormalViewZoom
  - PageBreakPreviewZoom
  - View
  - Selected
  - StandardHeight
  - StandardWidth
  - Hyperlinks
  - Shapes
  - Visible
  - Outline
  - IsProtected
  - Protection permissions
  - AutoFilterRange
  - AutoFilterColumns
  - Tables
  - TabColor
  - SheetTypeRaw
- Metode
TXLSWorksheets
- Proprietăți
- Metode
IXLSRange
- Proprietăți
  - Borders
  - Cells
  - coloană
  - Columns
  - ColumnWidth
  - Width
  - WidthInPixels
  - Comment
  - Count
  - EntireColumn
  - EntireRow
  - Font
  - formulă
  - FormulaHidden
  - HasFormula
  - HorizontalAlignment
  - Hyperlinks
  - IndentLevel
  - Interior
  - Item
  - Locked
  - NumberFormat
  - MergeArea
  - MergeCells
  - Offset
  - Orientation
  - OutlineLevel
  - ReadingOrder
  - Row
  - RowHeight
  - Rows
  - ShrinkToFit
  - valoare
  - VerticalAlignment
  - Worksheet
  - WrapText
  - interval bounds / XFIndex
  - Interfețe de interval de rând și de coloană
- Metode
  - AddComment
  - AutoFit
  - Autofilter
  - ApplyBuiltinStyle
  - ApplyFormat
  - CaptureFormat
  - Clear
  - ClearContents
  - ClearComments
  - ClearOutline
  - Copy
  - Delete
  - Group
  - Insert
  - Merge
  - Move
  - SaveAs
  - SaveAsCSV
  - SaveAsHTML
  - SetArrayFormula
  - PasteFrom / ShiftTo / ExtendRange / ContractRange
  - Select
  - UnGroup
  - Unmerge
IXLSPageSetup
- Proprietăți
IXLSInterior
- Proprietăți
- Metode
  - SetThemeColor
  - SetPatternThemeColor
IXLSBorder
- Proprietăți
  - Color
  - ColorIndex
  - LineStyle
  - Weight
- Metode
  - SetThemeColor
IXLSBorders
- Proprietăți
  - Color
  - ColorIndex
  - LineStyle
  - Weight
  - Item
IXLSFont
- Proprietăți
  - Name
  - Size
  - ColorIndex
  - Color
  - Bold
  - Italic
  - Strikethrough
  - OutLineFont
  - Shadow
  - CharSet / Family
  - Underline
  - SubScript
  - SuperScript
- Metode
  - SetThemeColor
TXLSHPageBreaks
- Proprietăți
  - Count
  - Item
- Metode
  - Add
TXLSHPageBreak
- Proprietăți
  - Location
- Metode
  - Delete
TXLSVPageBreaks
- Proprietăți
  - Count
  - Item
- Metode
  - Add
TXLSVPageBreak
- Proprietăți
  - Location
- Metode
  - Delete
TXLSComment
- Proprietăți
  - Visible
  - Text
  - Shape
TXLSFormatSnapshot
- Metode
  - ApplyTo
TXLSShape
- Proprietăți
  - Height
  - Width
  - Line
  - Fill
  - OfficeArtOptions
- Metode
  - Delete
TXLSTextBox
- Proprietăți
  - Text
  - TextRuns
  - Row1
  - Row1Offs
  - Col1
  - Col1Offs
  - Row2
  - Row2Offs
  - Col2
  - Col2Offs
- Metode
  - SetArea
TXLSOfficeArtOptions
- Members
  - IsDefined / LongValue / WideStringValue / Delete
TXLSShapes
- Proprietăți
  - Count
  - Items
- Metode
TXLSColorFormat
- Proprietăți
  - RGB
  - SchemeColor
- Free helpers (lxHandle unit)
  - XlsApplyThemeColorToDrawing — atribuie un idx de temă al registrului de lucru + o nuanță unui slot de culoare de desen (forme, umpleri de diagrame)
  - XlsGetDrawingThemeColor — recuperează idx-ul de temă + nuanța atribuite ultima dată unui slot de culoare de desen în cadrul aceluiași proces (începând cu v2.64.0)
TXLSFillFormat
- Proprietăți
  - ForeColor
  - Visible
- Metode
  - Solid
TXLSLineFormat
- Proprietăți
  - Style
  - DashStyle
  - ForeColor
  - Visible
  - Weight
IXLSHyperLinks
- Proprietăți
  - Count
  - Item
- Metode
  - Add
  - Delete
IXLSHyperLink
- Proprietăți
  - Address
  - Range
  - ScreenTip
  - SubAddress
  - DisplayText
- Metode
  - Delete
IXLSName
- Proprietăți
  - Name
  - RefersTo
  - RefersToRange
  - Visible
  - Index
  - Comment
- Metode
  - Delete
IXLSNames
- Proprietăți
  - Item
  - Count
- Metode
  - Add
  - FindByCell
TXLSOutline
- Proprietăți
TXLSVBAProject
- Proprietăți
  - Count / Item
TXLSVBAModule
- Proprietăți
  - Name / SourceCode
TXLSTable / TXLSTables
- TXLSTable properties
  - Id / Name / DisplayName / Range / Columns / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / TotalsRowShown
- TXLSTables members
  - Add (2 suprascrieri) / 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
- Proprietăți (per slot)
  - HasXxx / XxxColor / XxxColorIsTheme / XxxColorThemeId / XxxColorThemeTint
TXLSHTMLExport
- Proprietăți
  - Options / Title / SimpleExport / TableBorderWidth / CellPadding / CellSpacing
- Metode
  - Suprascrieri SaveAsHTML pentru ieșire către registru de lucru, foaie de lucru, interval, fișier și flux

Fațada XLSX (lxHandleX)

Prezentare generală și pornire rapidă
API de raportare compilată
Vederi de registru de lucru, conexiuni și XML Maps
Selecții de panouri ale foii de lucru
Tokenuri de formulă și funcții de utilizator
Redare și export avansate
Alți membri de API ai fațadei XLSX
- Clase de opțiuni și ajutoare
  - TXLSXHtmlExportOptions / XlsxColumnLabel / XlsxCellRef / XlsxColumnIndex / XlsxParseCellRef / XlsxParseRangeRef / XlsxEscapeText / XlsxEscapeAttr
Membri avansați ai API XLSX
TXLSXWorkbook
- Metode
  - CreateLoadedCellCursor
  - CreateReadOnlyView
  - SaveSemanticSnapshot / ComputeSemanticHash
  - CaptureRenderCalibration / ResetRenderCalibration
  - CreateRenderGeometry
  - ResolveIndexedColor
  - ScanIndexedColorUsage
  - BuildBiffPalettePlan
  - ApplyBiffPalettePlan
  - SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
- Proprietăți
  - Sheets / Fonts / Fills / Borders / NumberFormats / DefinedNames
  - RenderCalibration
TXLSXSharedStrings
- Members
  - Add / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
TXLSXSheets
- Metode
  - Add / Clear / IndexByName / SheetByName / TryGetSheetByName
- Proprietăți
  - Count / Items
TXLSXFont / TXLSXFonts
- TXLSXFont properties
  - Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto
- TXLSXFonts members
  - Add (3 suprascrieri) / 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 (fiecare = Style + Color + ColorIsAuto)
- Selectori de borduri de interval
  - TXLSXBorderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / selectori de muchii direcționale și diagonale
- 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 suprascrieri) / IndexOfName / Clear / Count / Items
TXLSXExternalLink / TXLSXExternalLinks
- TXLSXExternalLink properties
  - Target / SheetNames
- TXLSXExternalLinks members
  - Add / Clear / Count / Items
TXLSXWorksheet
- Metode
  - 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 / ClearPrinterDriverData / KeepRowLinkLevel / KeepColLinkLevel / SortRange / ClearRowHidden / ClearColHidden / ClearRowCollapsed / ClearColCollapsed / SetAutoFilter / AddAutoFilterColumn / AutoFilterRowVisible / PreviewAutoFilterRows / SetColWidth / SetRowHeight / EntireRow / EntireColumn / SetWorkbook / SetIsSelected / Subtotal / SubtotalDefaultEnglishString / AddRawDrawingAnchor / BringToFront / SendToBack / BringForward / SendBackward
- Proprietăți
  - Name / Visibility / Visible / IsSelected / Workbook / StructuralEditRegistry / 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 / PrinterDriverData / HasPrinterDriverData / 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 suprascrieri) / Clear / Count / Items
TXLSXComments / TXLSXComment
- TXLSXComment properties
  - Row / Col / Author / Text
- TXLSXComments members
  - Add (2 suprascrieri) / 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 / AnchorType / CropLeft / CropTop / CropRight / CropBottom / Transparency / Brightness / Contrast / Rotation / FillMode / HasPreservedXml / ClearPreservedXml
- TXLSXImages members
  - Add / Clear / Count / Items
TXLSXHeaderFooterImage / TXLSXHeaderFooterImages
- Proprietăți imagine
  - PageKind / Position / WidthPt / HeightPt / MarginLeftPt / MarginTopPt / Format / Data / Title
- Membri ai colecției
  - Add / AddFromFile / IndexOf / Find / Delete / Assign / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- TXLSXConditionalFormat properties
  - Range / Op / Formula1 / Formula2
- TXLSXConditionalFormats members
  - Add (2 suprascrieri) / 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 suprascrieri) / 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 / Color / 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

Prezentare generală

Celule și intervale

Referința componentelor

Referința claselor

Fațada XLSX (lxHandleX)

Exemple