Spreadsheet-SDK

HotXLS Component voor Delphi-spreadsheetapplicaties

Maak, bewerk, inspecteer, bereken en exporteer Excel-workbooks rechtstreeks vanuit Delphi- of C++Builder-code. HotXLS is een native Object Pascal-spreadsheetbibliotheek met broncode voor XLS- en XLSX-workflows, ontworpen voor desktoptools, batchtaken, rapportagesystemen en server-side documentgeneratie zonder Microsoft Excel-automatisering.

HotXLS Delphi Excel Spreadsheet Component

Native Excel-werkmapautomatisering voor Delphi en C++Builder

HotXLS Component is een Object Pascal-spreadsheetbibliotheek op bronniveau voor Delphi en C++Builder. De bibliotheek maakt nieuwe workbooks, opent bestaande Excel-bestanden, wijzigt werkbladen, evalueert formules, past opmaak toe en slaat het resultaat op zonder Microsoft Excel te starten, COM-automatisering te gebruiken of afhankelijk te zijn van een desktopinstallatie van Office.

Use it when your application needs repeatable workbook generation, template filling, report export, file conversion, workbook inspection, or controlled round-trip editing in an installer, service, batch tool, desktop utility, or line-of-business application.

Excel spreadsheet with cell coloring created by HotXLS and Delphi
Formatted Excel workbook generated from Delphi code with HotXLS.

Huidige release en platformdekking

Huidige HotXLS-release: versie 2.88.108. See the release notes for recent XLS, XLSX, formula, export, template-editing, protection, and round-trip preservation updates.

HotXLS ondersteunt Delphi XE5 tot Delphi 13 Florence en C++Builder XE5 tot C++Builder 13 Florence. Het pakket bevat Delphi- en C++Builder-demo’s, API-documentatie, voorbeelden voor werkmapbewerking en rapportexport, en volledige Object Pascal / Delphi-broncode voor gelicentieerde klanten.

Twee gerichte workbook-API's

API-oppervlakPrimair gebruik
lxHandleKlassieke Excel 97-2003 BIFF8 .xls workflows, including workbook read/write, formulas, formatting, comments, hyperlinks, chart sheets, pivot-table support, VBA payload preservation, HTML, RTF, CSV, and TSV exports.
lxHandleXExcel 2007+ OOXML .xlsx workflows, including workbook and stream I/O, style palettes, shared strings, worksheet tables, charts, comments, drawings, external links, XLSX-specific exports, and streaming write for larger sheets.

Belangrijkste mogelijkheden

  • XLS- en XLSX-werkmapworkflows: 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.
  • Cel-, bereik- en sjabloonbewerking: 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.
  • Opmaak en pagina-indeling: 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.
  • Formules en berekening: 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.
  • Werkmapgegevens: 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.
  • Afbeeldingen, grafieken en tekeningen: 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.
  • Beveiliging en versleuteling: 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.
  • Exporthelpers: 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.

Ontworpen voor gecontroleerde automatisering

HotXLS is useful when Office automation is not a good fit for a production workflow. Spreadsheet processing stays inside your application process, which reduces dependence on interactive desktop sessions and makes deployment easier for unattended tools and server-side jobs.

The library is developed around documented workbook structures and practical Excel interoperability. Recent releases focus on preserving Excel-authored records, workbook metadata, comments, hyperlinks, external-link data, worksheet state, protection options, VBA payloads, table data, AutoFilter state, drawing records, and view settings during open/save round trips. That approach helps applications make targeted edits without unnecessarily rewriting parts of the workbook they do not own.

HotXLS is an independent losLab Software product. Microsoft Excel is not required at runtime, and this page does not claim Microsoft certification, endorsement, or trademark ownership.

Veelvoorkomende gebruiksscenario's

ScenarioHoe HotXLS helpt
Report generationCreate styled workbooks from application data, database tables, DBGrid content, or callback-driven worksheet writers.
Template editingOpen an existing workbook, find and replace text placeholders, fill ranges, preserve surrounding metadata, and save the edited file.
Workbook inspectionRead sheet names, worksheet ranges, document properties, comments, hyperlinks, names, filters, and selected workbook metadata from controlled code.
Office-free exportGenerate Excel-compatible output on machines where Microsoft Office is not installed, including services and unattended batch jobs.
Legacy and modern workbook supportUse one component family for classic BIFF8 .xls workflows and current OOXML .xlsx workflows.
Preview and conversion pipelinesExport whole sheets or selected ranges to HTML, RTF, CSV, or TSV for previews, email fragments, imports, and downstream systems.
Auditable document pipelinesKeep workbook transformations inside your own Delphi or C++Builder code path instead of driving an external UI application.
Grouped Excel rows exported by HotXLS from a Delphi application
Grouped rows and formatted report output created through the HotXLS component API.

Evaluatie, licenties en ondersteuning

HotXLS Delphi Spreadsheet Component-demopakket downloaden to review the demos and API documentation before purchase.

Nieuwe commerciële licenties bevatten de volledige Object Pascal / Delphi-broncode, een jaar software-updates, een jaar e-mailondersteuning en royaltyvrij gebruik in onbeperkte toepassingen onder de gekozen ontwikkelaarslicentie.

Betaal met creditcard/debetkaart, PayPal, AliPay of bankoverschrijving:
HotXLS Single License ($499)
HotXLS Team/SME License ($999)
HotXLS Enterprise License ($1999)

Jaarlijkse verlenging kopen for existing licenses. Renewal pricing is listed on the HotXLS purchase page.

Open the HotXLS online documentation or contact losLab Software with licensing and technical questions.


Meer ontdekken van Delphi PDF Component & Spreadsheet Development

Abonneren op productupdates

Abonneer u om de nieuwste berichten per e-mail te ontvangen.