HotXLS belgeleri - İçindekiler

bileşenler başvuru

sınıflar başvuru

IXLSWorkbook
- Özellikler
- Yöntemler
TXLSWorksheet
- Özellikler
- Yöntemler
TXLSWorksheets
- Özellikler
- Yöntemler
IXLSRange
- Özellikler
- Yöntemler
IXLSPageSetup
- Özellikler
- Methods
  - SetPrintArea
  - ClearPrinterDriverData
IXLSInterior
- Özellikler
- Yöntemler
  - SetThemeColor
  - SetPatternThemeColor
IXLSBorder
- Özellikler
- Yöntemler
  - SetThemeColor
IXLSBorders
- Özellikler
IXLSFont
- Özellikler
- Yöntemler
  - SetThemeColor
TXLSHPageBreaks
- Özellikler
  - Count
  - Item
- Yöntemler
  - Add
TXLSHPageBreak
- Özellikler
  - Location
- Yöntemler
  - Delete
TXLSVPageBreaks
- Özellikler
  - Count
  - Item
- Yöntemler
  - Add
TXLSVPageBreak
- Özellikler
  - Location
- Yöntemler
  - Delete
TXLSComment
- Özellikler
TXLSFormatSnapshot
- Yöntemler
  - ApplyTo
TXLSShape
- Özellikler
- Yöntemler
  - Delete
TXLSTextBox
- Özellikler
- Yöntemler
  - SetArea
TXLSOfficeArtOptions
- Members
  - IsDefined / LongValue / WideStringValue / Delete
TXLSShapes
- Özellikler
  - Count
  - Items
- Yöntemler
Klasik form denetimleri
- TXLSButton
- TXLSRadioButton
- TXLSCheckBox
- TXLSComboBox
- TXLSListBox
TXLSColorFormat
- Özellikler
  - RGB
  - SchemeColor
- Free helpers (lxHandle unit)
  - XlsApplyThemeColorToDrawing — bir çizim renk yuvasına (şekiller, grafik dolguları) çalışma kitabı tema idx + ton atar
  - XlsGetDrawingThemeColor — aynı süreç içinde bir çizim renk yuvasına en son atanan tema idx + tonunu geri kazanır (v2.64.0'dan itibaren)
TXLSFillFormat
- Özellikler
  - ForeColor
  - Visible
- Yöntemler
  - Solid
TXLSLineFormat
- Özellikler
IXLSHyperLinks
- Özellikler
  - Count
  - Item
- Yöntemler
  - Add
  - Delete
IXLSHyperLink
- Özellikler
- Yöntemler
  - Delete
IXLSName
- Özellikler
- Yöntemler
  - Delete
IXLSNames
- Özellikler
  - Item
  - Count
- Yöntemler
  - Add
  - FindByCell
TXLSOutline
- Özellikler
TXLSVBAProject
- Özellikler
  - Count / Item
TXLSVBAModule
- Özellikler
  - Name / SourceCode
TXLSTable / TXLSTables
- TXLSTable özellikler
  - 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 sınıflar
  - TXLSCfValue / TXLSDataBarSpec / TXLSColorScaleSpec / TXLSIconSetSpec
- TCondFormatRule özellikler
  - 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
- özellikler (per slot)
  - HasXxx / XxxColor / XxxColorIsTheme / XxxColorThemeId / XxxColorThemeTint
TXLSHTMLExport
- Özellikler
  - Options / Title / SimpleExport / TableBorderWidth / CellPadding / CellSpacing
- Yöntemler
  - Çalışma kitabı, çalışma sayfası, aralık, dosya ve akış çıktısı için SaveAsHTML aşırı yükleri

XLSX cephesi (lxHandleX)

Genel bakış ve hızlı başlangıç
Derlenmiş raporlama API'si
Çalışma kitabı görünümleri, bağlantılar ve XML Haritaları
Çalışma sayfası bölme seçimleri
Formül belirteçleri ve kullanıcı işlevleri
Gelişmiş oluşturma ve dışa aktarma
Hesaplama ve dönüşüm doğruluğu
XLSB değerleri ve stiller
Ek XLSX cephesi API üyeleri
- Option sınıflar ve helpers
  - TXLSXHtmlExportOptions / XlsxColumnLabel / XlsxCellRef / XlsxColumnIndex / XlsxParseCellRef / XlsxParseRangeRef / XlsxEscapeText / XlsxEscapeAttr
Gelişmiş XLSX API üyeleri
TXLSXWorkbook
- Yöntemler
  - CreateLoadedCellCursor
  - CreateReadOnlyView
  - SaveSemanticSnapshot / ComputeSemanticHash
  - CaptureRenderCalibration / ResetRenderCalibration
  - CreateRenderGeometry
  - ResolveIndexedColor
  - ScanIndexedColorUsage
  - BuildBiffPalettePlan
  - ApplyBiffPalettePlan
  - SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
- Özellikler
  - Sheets / Fonts / Fills / Borders / NumberFormats / DefinedNames
  - RenderCalibration
TXLSXSharedStrings
- Members
  - Add / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
TXLSXSheets
- Yöntemler
  - Add / Clear / IndexByName / SheetByName / TryGetSheetByName
- Özellikler
  - Count / Items
TXLSXFont / TXLSXFonts
- TXLSXFont özellikler
  - Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto
- TXLSXFonts members
  - Add (3 overloads) / Clear / Count / Items
TXLSXFill / TXLSXFills
- TXLSXFill özellikler
  - Pattern / ForegroundColor / ForegroundIsAuto / BackgroundColor / BackgroundIsAuto
- TXLSXFills members
  - Add / AddSolid / Clear / Count / Items
TXLSXBorder / TXLSXBorders
- TXLSXBorder özellikler
  - Left / Right / Top / Bottom / Diagonal (each = Style + Color + ColorIsAuto)
- Aralık kenarlık seçicileri
  - TXLSXBorderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / yönlü ve çapraz kenar seçicileri
- TXLSXBorders members
  - Add / AddBox / Clear / Count / Items
  - LookupOrAdd
TXLSXNumberFormat / TXLSXNumberFormats
- Members
  - FormatCode / Add / IndexOf / Clear / Count / Items
TXLSXDefinedName / TXLSXDefinedNames
- TXLSXDefinedName özellikler
  - Name / Formula / SheetIndex / Hidden / Comment
- TXLSXDefinedNames members
  - Add (2 overloads) / IndexOfName / Clear / Count / Items
TXLSXExternalLink / TXLSXExternalLinks
- TXLSXExternalLink özellikler
  - Target / SheetNames
- TXLSXExternalLinks members
  - Add / Clear / Count / Items
TXLSXWorksheet
- Yöntemler
  - 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
- Özellikler
  - 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 özellikler
  - 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 özellikler
  - Row1 / Col1 / Row2 / Col2 / Ref
- TXLSXMergedCells members
  - Add / Clear / Count / Items
TXLSXHyperlinks / TXLSXHyperlink
- TXLSXHyperlink özellikler
  - Row / Col / Url / Display / Tooltip
- TXLSXHyperlinks members
  - Add (3 overloads) / Clear / Count / Items
TXLSXComments / TXLSXComment
- TXLSXComment özellikler
  - 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 özellikler
  - 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
- Görüntü özellikleri
  - PageKind / Position / WidthPt / HeightPt / MarginLeftPt / MarginTopPt / Format / Data / Title
- Koleksiyon üyeleri
  - Add / AddFromFile / IndexOf / Find / Delete / Assign / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- TXLSXConditionalFormat özellikler
  - Range / Op / Formula1 / Formula2
- TXLSXConditionalFormats members
  - Add (2 overloads) / Clear / Count / Items
TXLSXDataValidation / TXLSXDataValidations
- TXLSXDataValidation özellikler
  - 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 / TitleTextStyle / TitleLayout / PlotAreaLayout / ShowLegend / LegendPosition / LegendTextStyle / LegendLayout / 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

Genel bakış

hücreler ve aralıklar

bileşenler başvuru

sınıflar başvuru

XLSX cephesi (lxHandleX)

Örnekler