HotXLS Docs

HotXLS component help

Use this reference to find classic XLS automation and the expanded XLSX facade, including workbook, worksheet, range, formatting, image, page setup, hyperlink, name, chart, table, validation, filter, and export APIs.

Open Contents Explore XLSX Support Start With Overview

364

Classic XLS and expanded XLSX API, guide, and Pascal example topics are available directly in the web help.

Expanded XLSX Support

Start with the dedicated lxHandleX facade for Excel 2007+ workbooks, worksheet collections, styles, shared strings, defined names, and OOXML save/open workflows.

XLSX Facade Overview

Modern Worksheet Features

Use XLSX ranges, formulas, merged cells, hyperlinks, comments, images, tables, charts, conditional formatting, data validation, frozen panes, and auto-filter criteria.

TXLSXWorksheet class

XLSX Export and Examples

Review XLSX workbook APIs plus CSV, HTML, and RTF export helpers, then pair the reference with the XlsxDataExport, QuickStartXlsx, MemoryDataExport, and ApiTour demos.

TXLSXWorkbook class

XLSX Facade

Create, open, style, automate, and export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface.

XLSX Facade Overview

Workbook API

Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface.

IXLSWorkbook interface

Worksheet API

Manage sheets, ranges, page breaks, display settings, shapes, formulas, and sheet-level output.

IXLSWorksheet reference

Range Editing

Read and write values, formulas, rows, columns, borders, alignment, merging, grouping, and formatting.

IXLSRange interface

XLS Color Model

Review the ThemeColor, TintAndShade, and classic XLS palette-based formatting decision.

Classic XLS color model

Grid Export

Export DBGrid content to Excel with header, detail, grouping, formatting, and event hooks.

TGridToXLS component

Dataset Export

Export datasets to workbooks with field selection, worksheet naming, group styling, and save helpers.

TDataToXLS component

Pascal Examples

Open sample workflows for purchase orders, grouped exports, images, and common workbook automation.

Example topics

Release Notes

Review the HTML version history for HotXLS classic XLS, expanded XLSX, export, compatibility, and documentation updates.

Open release notes