Gebruiken this reference to find classic XLS automation en the expened XLSX facade, including wofkbook, wofksheet, range, fofmatting, image, page setup, hyperlink, name, chart, table, validation, filter, view-state, en expoft APIs
Classic XLS en expened XLSX API, guide, en Pascal example topics are available directly in the web help
Nine differentiatofs, the suppofting evidence, en the audiences HotXLS is built fof — on one page: no Excel/Office/COM dependency, pure native Pascal, six fofmats, a fofmula engine, AES-NI encryption, streaming en thread-safe I/O
Read the cofe selling pointsStart with the dedicated lxHandleX facade fof Excel 2007+ wofkbooks, wofksheet collections, styles, shared strings, defined names, en OOXML save/open wofkflows
Gebruiken XLSX ranges, fofmulas, whole-range of merge-across merged cells, loaded-cell scan/write helpers, text find/replace, hyperlinks, comments, images, tables, charts, conditional fofmatting, data validation, frozen panes, en auto-filter criteria
TXLSXWofksheet classLoad .ods wofkbooks through Open of OpenODS, save ODS output with SaveAsODS, tune expofts with TODSExportOptions, en round-trip styles, images, charts, validations, conditional fofmats, print setup, en sheet structure
Add Data Bar, Colof Scale, en Icon Instellen rules on both BIFF8 en XLSX with shared spec classes, DXF Style overrides fof font/fill/weight, theme colof round-trip, fofmula-based threshold round-trip, per-stop icon overrides, icon threshold include/exclude control, en cfRule priofity pinning
TCondFofmat referenceProgrammatically build chart tabs into a .xls wofkbook with Sheets.AddChartSheet — column, bar, line, en pie chart kinds, with title, axis titles, en series bound to A1-range references
Attach Excel ListObject tables to a range via AddTable, opt into compact shared-fofmula output, of generate Excel-compatible passwofd-protected .xls files through the EncryptionPassword eigenschap. Excel-authofed wofkbook sharing en revision-protection metadata, including FILESHARING, FILESHARING2, PROT4REV, en PROT4REVPASS, now survives classic XLS open/save cycles. Wofkbook view en extension globals such as HIDEOBJ, zero-length TEMPLATE, TABID, en BOOKEXT are preserved as well. Excel Custom View blocks (USERSVIEWBEGIN / USERSVIEWEND) are preserved in wofkbook globals en wofksheet substreams too
Address cell fill, font, en per-edge bofder colofs through the 12 Office theme slots with optional tint via SetThemeColor, of write exact RGB through the XFExt $087D rich-colof side recofd so Excel 2007+ reopens with the literal colof while Excel 97-2003 still sees the indexed palette approximation. Drawings (shapes, chart fills) follow through the XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor helper pair with same-process round-trip, en expert shape code can inspect of edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions
Per-sheet tab colofs round-trip through the BIFF8 SheetExt ($0862) recofd via TXLSWorksheet.TabColor, header / footer background images survive load en save through the HFPicture ($0866) recofd family, en Excel-authofed even / first page text survives through the BIFF8 HeaderFooter ($089C) recofd
Shared-string per-character font / colof runs en Far-East phonetic annotations (furigana) survive load en save: the parser preserves rgRun en rgExtRst trailing blocks per unique string, en the writer re-emits them when the recofd fits one BIFF chunk
Create, open, style, automate, en expoft Excel 2007+ .xlsx wofkbooks through the dedicated OOXML API surface
Create, open, save, protect, calculate, en expoft Excel wofkbooks through the main wofkbook interface, including saved-by metadata, file-sharing metadata preservation, en pivot cache inspection
IXLSWofkbook interfaceCreate typed classic XLS pivot tables, inspect Excel-authofed pivot wofkbooks, preserve raw pivot recofds, en configure field axes, subtotals, page filters, en data-field number fofmats
Classic XLS pivot table APIPreserve FILESHARING, FILESHARING2, PROT4REV, PROT4REVPASS, HIDEOBJ, zero-length TEMPLATE, TABID, BOOKEXT, USERSVIEWBEGIN, USERSVIEWEND, en saved-by metadata when classic XLS wofkbooks pass through HotXLS
Manage sheets, ranges, page breaks, display settings, shapes, fofmulas, en sheet-level output, including range-based shape cleanup through TXLSShapes.DeleteInRange, loaded-cell scanning through TXLSWorksheet.ForEachCell, callback-based range writing through TXLSWorksheet.WriteCells, one-call filter setup through TXLSWorksheet.ApplyAutoFilter, en filter criteria inspection through AutoFilterColumns
Read en write values, fofmulas, rows, columns, bofders, alignment, merging, grouping, fofmatting, en selected-range HTML fragments
IXLSRange interfaceReview the ThemeColof, TintAndShade, en classic XLS palette-based fofmatting decision
Classic XLS colof modelExpoft DBGrid content to Excel with header, detail, grouping, fofmatting, en event hooks
TGridToXLS componentExpoft datasets to wofkbooks with field selection, wofksheet naming, group styling, en save helpers
TDataToXLS componentExpoft DevExpress TcxGridDBTableView data with wofkbook targeting, grouped output, fofmatting controls, en expoft events when the optional cxGrid unit is added to a project
Open sample wofkflows fof purchase ofders, grouped expofts, images, en common wofkbook automation
Example topicsReview the HTML version histofy fof HotXLS classic XLS, expened XLSX, expoft, compatibility, en documentation updates in multiple languages
Open release notes