- Overview i quick start
- Dodatkowe elementy API fasady XLSX
- Option klasy i helpers
- TXLSXHtmlExportOptions / XlsxColumnLabel / XlsxCellRef / XlsxColumnIndex / XlsxParseCellRef / XlsxParseRangeRef / XlsxEscapeText / XlsxEscapeAttr
- TXLSXWorkbook
- Metody
- SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
- Właściwości
TXLSXSharedStrings
- Members
- dodać / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
TXLSXSheets
- Metody
- dodać / Clear / IndexByName / SheetByName / TryGetSheetByName
- Właściwości
TXLSXFont / TXLSXFonts
- TXLSXFont właściwości
- nazwa / Size / Bold / Italic / Strikethrough / Underline / kolor / ColorIsAuto
- TXLSXFonts members
TXLSXFill / TXLSXFills
- TXLSXFill właściwości
- Pattern / ForegroundColor / ForegroundIsAuto / BackgroundColor / BackgroundIsAuto
- TXLSXFills members
- dodać / AddSolid / Clear / Count / Items
TXLSXBorder / TXLSXBorders
zakres obramowanie selectors
- TXLSXBorderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / directional i diagonal edge selectors
TXLSXBorders members
- dodać / AddBox / Clear / Count / Items
- LookupOrAdd
TXLSXNumberFormat / TXLSXNumberFormats
- Members
- FormatCode / dodać / IndexOf / Clear / Count / Items
TXLSXDefinedName / TXLSXDefinedNames
TXLSXDefinedNames members
TXLSXExternalLink / TXLSXExternalLinks
- TXLSXExternalLink właściwości
- TXLSXExternalLinks members
- dodać / Clear / Count / Items
TXLSXWorksheet
- Metody
- 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
- Właściwości
- 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
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 właściwości
- Row / Col / Value / FormatIndex / FontIndex / FillIndex / BorderIndex / NumberFormatIndex / NumberFormat / AlignmentIndex / ProtectionIndex / Formula / RichText / Locked / FormulaHidden / Workbook / ArrayRootRow / ArrayRootCol / ArrayLastRow / ArrayLastCol
- TXLSXCells members
- Utwórz / Destroy / Remove / Item[wiersz, Col] / Count / CellByIndex / HasCell / Clear
TXLSXMergedCells / TXLSXMergedRange
- TXLSXMergedRange właściwości
- Row1 / Col1 / Row2 / Col2 / Ref
- TXLSXMergedCells members
- dodać / Clear / Count / Items
TXLSXHyperlinks / TXLSXHyperlink
TXLSXHyperlinks members
TXLSXComments / TXLSXComment
- TXLSXComment właściwości
- wiersz / Col / Author / tekst
- TXLSXComments members
TXLSXAutoFilterColumn / TXLSXAutoFilterColumns
- Members
- ColId / Op1 / Op2 / Criteria1 / Criteria2 / TXLSXAutoFilterOp / IndexOfColId / FindByColId / DeleteByColId / Clear / Count / Items
TXLSXImage / TXLSXImages
TXLSXImages members
- dodać / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- TXLSXConditionalFormat właściwości
- zakres / Op / Formula1 / Formula2
- TXLSXConditionalFormats members
TXLSXDataValidation / TXLSXDataValidations
- TXLSXDataValidation właściwości
- zakres / ValidationType / Op / Formula1 / Formula2 / AllowBlank / ShowInputMessage / ShowErrorMessage / PromptTitle / Prompt / ErrorTitle / ErrorMessage / ErrorStyle / ShowDropDown
- TXLSXDataValidations members
TXLSXTable / TXLSXTables
- Members
- nazwa / DisplayName / Ref / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / dodać / usunąć / 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
TXLSXRichText
- Members
- TXLSXRichTextRun tekst / nazwa / Size / Bold / Italic / Strikethrough / Underline / kolor / ColorIsAuto / VertAlign / AddRun / AddRunText / Clear / RunCount / PlainText / Runs
TXLSXAlignment / TXLSXAlignments
TXLSXProtection / TXLSXProtections
- Members
- Locked / FormulaHidden / IsDefault / dodać / IndexOf / Clear / Count / Items