• XLS and XLSX workbook workflows: create, open, modify, and save Excel workbooks from files or streams, and quickly list sheet names from XLS or XLSX packages without loading every worksheet.
• Cell, range, and template editing: read and write numbers, strings, dates, booleans, formulas, merged cells, row and column sizes, hidden rows and columns, outlines, selections, and workbook ranges. Callback helpers can scan loaded cells, fill ranges, find text, and replace template placeholders.
• Formatting and page layout: apply fonts, colors, borders, fills, alignment, number formats, rich text, theme colors, indexed palettes, tab colors, page setup, headers, footers, print titles, page breaks, and worksheet view options.
• Formulas and calculation: evaluate formulas through the built-in calculation engine for classic XLS and XLSX workbooks, including cell references, ranges, cross-sheet references, defined names, and application-defined functions through an OnUserFunction callback.
• Workbook data features: work with hyperlinks, internal sheet anchors, defined names, comments, conditional formats, data validation, AutoFilter ranges and criteria, Excel-style tables, document properties, external links, and pivot-table records.
• Images, charts, and drawings: embed images, create worksheet charts and chart sheets, preserve VBA project payloads, and keep Excel-authored OfficeArt connector, solver, shape, and comment metadata stable during round-trip saves where supported.
• Protection and encryption: handle worksheet and workbook protection, classic XLS password workflows, and XLSX AES-protected save output while keeping unsupported encrypted-package read paths explicit in the developer documentation.
• Export helpers: export workbooks, worksheets, selected ranges, database tables, and DBGrid content to Excel, HTML, RTF, CSV, and TSV outputs, including HTML table fragments for previews, emails, or web reports.

uses
  lxHandle;

procedure CreateQuickWorkbook;
var
  Book: IXLSWorkbook;
  Sheet: TXLSWorksheet;
  I: Integer;
begin
  Book := TXLSWorkbook.Create;
  Sheet := Book.Sheets.Add;
  Sheet.Name := 'Quick Start';
  Sheet.Cells.Item[1, 1].Value := 'Product';
  Sheet.Cells.Item[1, 2].Value := 'Units';
  for I := 2 to 5 do
  begin
    Sheet.Cells.Item[I, 1].Value := Format('Item %d', [I - 1]);
    Sheet.Cells.Item[I, 2].Value := I * 10;
  end;
  Sheet.Cells.Item[6, 2].Value := '=SUM(B2:B5)';
  Book.SaveAs('QuickStart.xls');
end;