Delphi ve C++Builder için yerel Excel çalışma kitabı otomasyonu
HotXLS Component Delphi ve C++Builder için kaynak kod seviyesinde bir Object Pascal elektronik tablo kütüphanesidir. Yeni çalışma kitapları oluşturur, mevcut Excel dosyalarını açar, sayfaları değiştirir, formülleri hesaplar, biçimlendirme uygular ve sonucu Microsoft Excel başlatmadan, COM otomasyonu kullanmadan veya masaüstü Office kurulumuna bağlı kalmadan kaydeder.
Uygulamanız tekrarlanabilir çalışma kitabı üretimi, şablon doldurma, rapor dışa aktarma, dosya dönüştürme, çalışma kitabı inceleme veya kurulum aracı, servis, batch aracı, masaüstü yardımcı programı ya da iş uygulamasında kontrollü round-trip düzenleme gerektirdiğinde kullanın.
Geçerli sürüm ve platform kapsamı
Güncel HotXLS sürümü: 2.88.108. See the release notes for recent XLS, XLSX, formula, export, template-editing, protection, and round-trip preservation updates.
HotXLS, Delphi XE5’ten Delphi 13 Florence’a ve C++Builder XE5’ten C++Builder 13 Florence’a kadar destekler. Paket; Delphi ve C++Builder demoları, API belgeleri, çalışma kitabı düzenleme ve rapor dışa aktarma örnekleri ve lisanslı müşteriler için tam Object Pascal / Delphi kaynak kodu içerir.
İki odaklı workbook API'si
| API yüzeyi | Temel kullanım |
|---|---|
lxHandle | Klasik 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. |
lxHandleX | Excel 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. |
Temel yetenekler
- XLS ve XLSX çalışma kitabı iş akışları: 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.
- Hücre, aralık ve şablon düzenleme: 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.
- Biçimlendirme ve sayfa düzeni: 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.
- Formüller ve hesaplama: 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
OnUserFunctioncallback. - Çalışma kitabı verileri: 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.
- Görüntüler, grafikler ve çizimler: 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.
- Koruma ve şifreleme: 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.
- Dışa aktarma yardımcıları: 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.
Kontrollü otomasyon için tasarlandı
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.
Yaygın kullanım senaryoları
| Scenario | HotXLS nasıl yardımcı olur |
|---|---|
| Report generation | Create styled workbooks from application data, database tables, DBGrid content, or callback-driven worksheet writers. |
| Template editing | Open an existing workbook, find and replace text placeholders, fill ranges, preserve surrounding metadata, and save the edited file. |
| Workbook inspection | Read sheet names, worksheet ranges, document properties, comments, hyperlinks, names, filters, and selected workbook metadata from controlled code. |
| Office-free export | Generate Excel-compatible output on machines where Microsoft Office is not installed, including services and unattended batch jobs. |
| Legacy and modern workbook support | Use one component family for classic BIFF8 .xls workflows and current OOXML .xlsx workflows. |
| Preview and conversion pipelines | Export whole sheets or selected ranges to HTML, RTF, CSV, or TSV for previews, email fragments, imports, and downstream systems. |
| Auditable document pipelines | Keep workbook transformations inside your own Delphi or C++Builder code path instead of driving an external UI application. |
Değerlendirme, lisanslama ve destek
HotXLS Delphi Spreadsheet Component-demopakket downloaden to review the demos and API documentation before purchase.
Yeni ticari lisanslar; tam Object Pascal / Delphi kaynak kodu, bir yıl yazılım güncellemesi, bir yıl e-posta desteği ve seçilen geliştirici sayısı lisansı kapsamında sınırsız uygulamada telifsiz kullanım içerir.
Betaal met creditcard/debetkaart, PayPal, AliPay of bankoverschrijving:
HotXLS Single License ($499)
HotXLS Team/SME License ($999)
HotXLS Enterprise License ($1999)
Yıllık yenileme satın al 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
Ürün güncellemelerine abone olun
En son gönderileri e-posta ile almak için abone olun.
