HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages.

for the klasė full hierarchy exposed bylxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesle)

uses lxHandle;

var
  Book: IXLSWorkbook;
  ws:   TXLSWorksheet;
begin
  Book := TXLSWorkbook.Create;
  // Add a worksheet and give it a name
  ws := Book.Sheets.Add;
  ws.Name := 'Sheet1';

  // Write values to cells using A1 notation
  ws.Range['A1'].Value := 'Hello';
  ws.Range['B1'].Value := 42;
  ws.Range['C1'].Formula := '=B1*2';

  // Apply basic formatting
  ws.Range['A1'].Font.Bold := True;
  ws.Range['A1'].Interior.Color := clYellow;

  Book.SaveAs('output.xls');
end;

Quick StartlxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX)

uses lxHandleX;

var
  Book: TXLSXWorkbook;
  ws:   TXLSXWorksheet;
  cell: TXLSXCell;
begin
  Book := TXLSXWorkbook.Create;
  try
    ws := Book.Sheets.Add('Sheet1');

    // Write a string and a numeric value
    ws.Cells[1, 1].Value := 'Product';
    ws.Cells[1, 2].Value := 'Price';
    ws.Cells[2, 1].Value := 'Widget';
    ws.Cells[2, 2].Value := 9.99;

    // Apply a currency number format
    cell := ws.Cells[2, 2];
    cell.NumberFormat := '$#,##0.00';

    Book.SaveAs('output.xlsx');
  finally
    Book.Free;
  end;
end;

Book: Export-only formats; ws: XLSX Facade HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages. (lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX);

Book := TXLSWorkbook.Create;

• 'Sheet1'LEFT, MID, TRIM, SUBSTITUTE, …)
• 'A1'DATE, NETWORKDAYS, WORKDAY, …)
• 'Hello'BIN2DEC, HEX2DEC, …)
• ].Value := 42; ws.Range[BITAND, BITOR, BITXOR, …)
• '=B1*2'AVERAGE, SUMIF, COUNTIFS, …)
• ws.Range[ROUND, MOD, POWER, …)

Quick Start

• var — name, size, color (RGB or theme color + tint), bold, italic, underline, strikethrough, superscript, subscript, shadowPaperSize outline
• begin — horizontal for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples vertical alignment, text orientation (angle), indent level, wrap text, shrink-to-fitPaperSize reading order (RTL/LTR)
• ws := Book.Sheets.Add( — all four edges for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples diagonals, line style, weightPaperSize RGB / theme color
• ws.Cells[1, 1].Value := — solid fill, pattern fills, foreground for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples background colors including theme color with TintAndShade
• ; ws.Cells[1, 2].Value := — built-in for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples custom format strings for date, time, currency, percentagePaperSize scientific notation
• 'Widget' — add, readPaperSize style cell comments

cell := ws.Cells[2, 2]; cell.NumberFormat :=

• finally
• Book.Free;
• end
• For a broader walkthrough that covers both . Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS throughs in a single demo project, see the
• usesApplyBuiltinStyle)
• lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesle;XLSX Facade HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages. (lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX).SelectAreas)
• Read existing Excel files, write new or existing Excel files, hfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesle classic XLS password protection for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX encrypted-save workflowsPaperSize quickly list sheet names from XLS for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX files or streams without loading the entire workbook. Opening a Charts: add chart sheets Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) embedded charts via as a workbook is supported through

Cell Values for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples Formulas

• // Write values to cells using A1 notation
• 'A1'
• // Write values to cells using A1 notation
• // Write values to cells using A1 notation
• ].Value := 42; ws.Range[
• // Write values to cells using A1 notation
• View options: gridline color, display formula mode, display zeros, display headings, display right-to-left, display outline symbolsPaperSize zoom level
• ws.Range[TXLSTable / TXLSXTable): add, accessPaperSize style Excel tables with header rows for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples bfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesed rows
• ].Interior.Color := clYellow; Book.SaveAs( XLSX Facade HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages. (lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX)sAddChartSheet for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples TXLSXChart

Quick Start

ws := Book.Sheets.Add(

'Widget'

• '$#,##0.00' (XLSX . Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through) provide a rich set of range operations:)
• Book.Free;
• Header for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples footer strings with Excel formatting codes (bold, italic, page number, date, etc.; see Apply built-in named cell styles ()
• lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesle;
• Read existing Excel files, write new or existing Excel files, hfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesle classic XLS password protection for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX encrypted-save workflowsPaperSize quickly list sheet names from XLS for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX files or streams without loading the entire workbook. Opening a Charts: add chart sheets Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) embedded charts via as a workbook is supported through
• Read for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples write cell values of all native Excel types: number, string, date/time, booleanPaperSize formula The built-in calculation engine evaluates formulas in both classic XLS for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX workbooks, supporting:

Sheet name, tab color, visibility (hidden / very-hidden)PaperSize index-based navigation

• AutoFilter ranges with criteria; list data validation rules — full document or an inline table fragment for preview or email workflows; controllable via TXLSAutoFilter ranges with criteria; list data validation rulesExport for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples TXLSXHtmlExportOptions
• Structured tables ( — rich text for word-processor import
• Charts: add chart sheets Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) embedded charts via — comma-separated values with configurable delimiter for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples encoding
• Add Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) read hyperlinks (URL, mailto, Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) in-workbook cell references) through — tab-separated values
• Images Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) Shapes — OpenDocument Spreadsheet via the lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX . Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through

for expert drawing workflows

Header for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples footer strings with Excel formatting codes (bold, italic, page number, date, etc.; see

— full document or an inline table fragment for preview or email workflows; controllable via

— rich text for word-processor import

• XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney, 11 Alexfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesria, 12 Athens, 13 Florence — full class hierarchy for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples XLSX/Images Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) Shapes-specific API members
• uses — first demo to run when learning HotXLS from scratch
• Export-only formats — classic XLS workbook interface reference
• XLSX Facade HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages. (lxHfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesleX) — classic XLS worksheet class reference
• — first demo to run when learning HotXLS from scratch — range interface: cell access, formattingPaperSize operations
• — classic XLS sąsaja workbook reference — XLSX workbook class reference
• — first demo to run when learning HotXLS from scratch — XLSX worksheet class reference
• — XLSX klasė workbook reference — drop-in DBGrid-to-Excel export component
• — XLSX klasė worksheet reference — drop-in dataset-to-Excel export component
• ].Interior.Color := clYellow; Book.SaveAs( — custom worksheet function extension point
• HotXLS overview: high-performance Excel XLS/XLSX read-write library for facade. Migrating one file format at a time is safe for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples incremental for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples C++Builder. No Microsoft Office required. Covers dual-. Create stfor the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examplesalone text boxes in classic XLS through architecture, key features, quick-start code, compatibility matrixPaperSize advantages. — palette-based color for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples theme color design rationale
• — palette-based color for the signature Find-text Fit-to-pages scaling; zoom percentage; print area; print titles (repeat rows / columns) replace-text across a worksheet examples theme color design rationale — calculation properties, document properties, pivot tablesPaperSize more
• Examples — sample projects overview
• — full-featured XLS creation example with source code — full-featured XLS creation example with source code