Dokumentacija HotXLS

Lastnosti TXLSTable
- Id / Name / DisplayName / Range / Columns / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / TotalsRowShown
Člani TXLSTables
- Add (2 preobremenitvi) / Delete / Clear / Count / Items

TCondFormat / TCondFormatRule

Enumeracije
- TXLSCfValueKind / TXLSIconSetType
Razredi specifikacij
- TXLSCfValue / TXLSDataBarSpec / TXLSColorScaleSpec / TXLSIconSetSpec
Lastnosti TCondFormatRule
- Kind / cfType / Operator_ / DataBar / ColorScale / IconSet / Style / DxfBlob
Člani TCondFormat
- ClearRow / ClearCol / ClearRange / MoveRanges / Range / IsEmpty / IsExt12

TXLSDxfStyle

Setterji
- SetFontColor / SetFontColorTheme / SetFillBgColor / SetFillBgColorTheme / SetFillFgColor / SetFillFgColorTheme / SetFillPattern / SetFontBold / SetFontItalic / SetFontUnderline / SetNumFormatId
Lastnosti (na režo)
- HasXxx / XxxColor / XxxColorIsTheme / XxxColorThemeId / XxxColorThemeTint

TXLSHTMLExport

Lastnosti
- Options / Title / SimpleExport / TableBorderWidth / CellPadding / CellSpacing
Metode
- Preobremenitve SaveAsHTML za izhod delovnega zvezka, delovnega lista, obsega, datoteke in toka

Fasada XLSX (lxHandleX)

Pregled in hiter začetek
API za prevedena poročila
Pogledi delovnega zvezka, povezave in preslikave XML
Izbire podokna delovnega lista
Žetoni formul in uporabniške funkcije
Napredno upodabljanje in izvoz
Dodatni člani API-ja fasade XLSX
Napredni člani API-ja XLSX
TXLSXWorkbook
- Metode
  - CreateLoadedCellCursor
  - CreateReadOnlyView
  - SaveSemanticSnapshot / ComputeSemanticHash
  - CaptureRenderCalibration / ResetRenderCalibration
  - CreateRenderGeometry
  - ResolveIndexedColor
  - ScanIndexedColorUsage
  - BuildBiffPalettePlan
  - ApplyBiffPalettePlan
  - SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
- Lastnosti
  - Sheets / Fonts / Fills / Borders / NumberFormats / DefinedNames
  - RenderCalibration
TXLSXSharedStrings
- Člani
  - Add / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
TXLSXSheets
- Metode
  - Add / Clear / IndexByName / SheetByName / TryGetSheetByName
- Lastnosti
  - Count / Items
TXLSXFont / TXLSXFonts
- Lastnosti TXLSXFont
  - Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto
- Člani TXLSXFonts
  - Add (3 preobremenitve) / Clear / Count / Items
TXLSXFill / TXLSXFills
- Lastnosti TXLSXFill
  - Pattern / ForegroundColor / ForegroundIsAuto / BackgroundColor / BackgroundIsAuto
- Člani TXLSXFills
  - Add / AddSolid / Clear / Count / Items
TXLSXBorder / TXLSXBorders
- Lastnosti TXLSXBorder
  - Left / Right / Top / Bottom / Diagonal (vsaka = Style + Color + ColorIsAuto)
- Izbirniki obrob obsega
  - TXLSXBorderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / usmerjeni in diagonalni izbirniki robov
- Člani TXLSXBorders
  - Add / AddBox / Clear / Count / Items
  - LookupOrAdd
TXLSXNumberFormat / TXLSXNumberFormats
- Člani
  - FormatCode / Add / IndexOf / Clear / Count / Items
TXLSXDefinedName / TXLSXDefinedNames
- Lastnosti TXLSXDefinedName
  - Name / Formula / SheetIndex / Hidden / Comment
- Člani TXLSXDefinedNames
  - Add (2 preobremenitvi) / IndexOfName / Clear / Count / Items
TXLSXExternalLink / TXLSXExternalLinks
- Lastnosti TXLSXExternalLink
  - Target / SheetNames
- Člani TXLSXExternalLinks
  - 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 / SortRange / ClearRowHidden / ClearColHidden / ClearRowCollapsed / ClearColCollapsed / SetAutoFilter / AddAutoFilterColumn / AutoFilterRowVisible / PreviewAutoFilterRows / SetColWidth / SetRowHeight / EntireRow / EntireColumn / SetWorkbook / SetIsSelected
- Lastnosti
  - 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
- Člani
  - RegisterParticipant / UnregisterParticipant / Clear / Count
TXLSFormulaDebugger
- Člani
  - Analyze / Formula / FinalValue / Nodes / Dependencies / StepNodes / CurrentNode / MoveFirst / MoveNext / MovePrevious / SeekNode / Reset / ErrorOriginNodeId / ErrorCode / ErrorText
TXLSPaginationModel
- Člani
  - Build / Clear / Count / Pages / RenderPage / CreatePageMetafile / SavePageAsMetafile / UseWorksheetPageSetup / Orientation / Margin / DefaultRowHeight
TXLSXRange
- Člani
  - 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
- Lastnosti TXLSXCell
  - Row / Col / Value / FormatIndex / FontIndex / FillIndex / BorderIndex / NumberFormatIndex / NumberFormat / AlignmentIndex / ProtectionIndex / Formula / RichText / Locked / FormulaHidden / Workbook / ArrayRootRow / ArrayRootCol / ArrayLastRow / ArrayLastCol
- Člani TXLSXCells
  - Create / Destroy / Remove / Item[vrstica, Col] / Count / CellByIndex / HasCell / Clear
TXLSXMergedCells / TXLSXMergedRange
- Lastnosti TXLSXMergedRange
  - Row1 / Col1 / Row2 / Col2 / Ref
- Člani TXLSXMergedCells
  - Add / Clear / Count / Items
TXLSXHyperlinks / TXLSXHyperlink
- Lastnosti TXLSXHyperlink
  - Row / Col / Url / Display / Tooltip
- Člani TXLSXHyperlinks
  - Add (3 preobremenitve) / Clear / Count / Items
TXLSXComments / TXLSXComment
- Lastnosti TXLSXComment
  - vrstica / Col / Author / Text
- Člani TXLSXComments
  - Add (2 preobremenitvi) / Clear / Count / Items
TXLSXAutoFilterColumn / TXLSXAutoFilterColumns
- Člani
  - ColId / Op1 / Op2 / Criteria1 / Criteria2 / TXLSXAutoFilterOp / IndexOfColId / FindByColId / DeleteByColId / Clear / Count / Items
TXLSXImage / TXLSXImages
- Lastnosti TXLSXImage
  - Row / Col / WidthEMU / HeightEMU / Format / Data / AnchorType / CropLeft / CropTop / CropRight / CropBottom / Transparency / Brightness / Contrast / Rotation / FillMode / HasPreservedXml / ClearPreservedXml
- Člani TXLSXImages
  - Add / Clear / Count / Items
TXLSXHeaderFooterImage / TXLSXHeaderFooterImages
- Lastnosti slike
  - PageKind / Position / WidthPt / HeightPt / MarginLeftPt / MarginTopPt / Format / Data / Title
- Člani zbirke
  - Add / AddFromFile / IndexOf / Find / Delete / Assign / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- Lastnosti TXLSXConditionalFormat
  - obseg / Op / Formula1 / Formula2
- Člani TXLSXConditionalFormats
  - Add (2 preobremenitvi) / Clear / Count / Items
TXLSXDataValidation / TXLSXDataValidations
- Lastnosti TXLSXDataValidation
  - obseg / ValidationType / Op / Formula1 / Formula2 / AllowBlank / ShowInputMessage / ShowErrorMessage / PromptTitle / Prompt / ErrorTitle / ErrorMessage / ErrorStyle / ShowDropDown
- Člani TXLSXDataValidations
  - Add (2 preobremenitvi) / AddList / Clear / Count / Items
TXLSXTable / TXLSXTables
- Člani
  - Name / DisplayName / Ref / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / Add / Delete / Clear / Count / Items
TXLSXChart / TXLSXCharts
- Člani
  - ChartType / xlsxChartScatter / xlsxChartBubble / xlsxChartRadar / Title / CategoryAxisTitle / ValueAxisTitle / FromRow / FromCol / ToRow / ToCol / AddSeries / BubbleSizeRange / ClearSeries / SeriesCount / Series / Add / Clear / Count / Items
TXLSXChartTextStyle
TXLSXChartLayout
TXLSXRichText
- Člani
  - TXLSXRichTextRun Text / Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto / VertAlign / AddRun / AddRunText / Clear / RunCount / PlainText / Runs
TXLSXAlignment / TXLSXAlignments
- Člani
  - Horizontal / Vertical / WrapText / ShrinkToFit / TextRotation / Indent / Add / Clear / Count / Items
TXLSXProtection / TXLSXProtections
- Člani
  - Locked / FormulaHidden / IsDefault / Add / IndexOf / Clear / Count / Items
TXLSXNamedStyle / TXLSXNamedStyles
- Člani
  - Name / XfId / BuiltInId / CustomBuiltIn / Hidden / BuiltinLevel / Add / Clear / Count / Items
TXLSXProtectedRange / TXLSXProtectedRanges
- Člani
  - Name / Sqref / Password / SecurityDescriptor / Add / Clear / Count / Items

Primeri

Naročilnica
Izvoz podatkov z grupiranjem
Izvoz podatkov z grupiranjem
Uporaba slike
Predstavitev API-ja za nove uporabnike
Predstavitev API-ja za nove uporabnike
Napredni delovni tokovi delovnega zvezka
Pretakanje velikih preglednic
Bralnik naprej
Neposredni bralnik in zapisovalnik (API)
Prevedena poročila
Komponenta pregledovalnika delovnega zvezka in demo
Hitri zagon XLSX in predstavitve zmožnosti
Napredna predstavitev InteractiveFeatures

Pregled

Celice in obsegi

Referenca komponent

Referenca razredov

Fasada XLSX (lxHandleX)

Primeri