 |
HotXLS Excel Read/Write Library is a high-performance Excel read-write component for Delphi & C++Builder. It can create new Excel spreadsheets and read or modify existing XLS and XLSX workbooks.
HotXLS is written in Object Pascal. It does not require Microsoft Excel /Office to be installed, and it reads and writes Excel files directly. HotXLS works with Delphi and C++Builder XE5 through 13 Florence.
Classic XLS colour formatting intentionally remains palette-based. See Classic XLS colour model for the ThemeColor / TintAndShade decision.
|
Features
|
1.
|
Read existing Excel files, write new or existing Excel files, handle classic XLS password protection and XLSX encrypted save workflows, and quickly list sheet names from XLS and XLSX files or streams.
|
|
|
2.
|
Access cell values, including number, string, date, boolean and formula.
|
 |
|
3.
|
Built-in calculation engine supports formula evaluation in classic XLS and XLSX workbooks, with an
OnUserFunction callback for custom or unsupported worksheet functions.
|
|
|
4.
|
Support cell attributes: orientation, alignment, borders, comments, background attributes.
|
|
|
5.
|
Support merge cells, copy/move/delete/insert range of cells, support group rows and columns.
|
|
|
6.
|
Support font attributes: font, font size/colour/decoration, support images, create standalone classic XLS text boxes through
TXLSShapes.AddTextBox, preserve Excel-created OfficeArt connector and solver rules in BIFF8 .xls drawings, and expose raw shape FOPT options through TXLSShape.OfficeArtOptions for expert drawing workflows.
|
|
|
7.
|
Support unicode characters, manipulate excel files written in any languages.
|
 |
|
8.
|
Support hyperlinks, Excel defined names, worksheet lookup by name, multi-area selection, and preserved VBA project payloads with read-only module inspection.
|
|
|
9.
|
Support Worksheet attributes: name, protection, selection, outline, AutoFilter ranges and criteria, list data validation, view state, gridline colour, frozen-pane flags, and others.
|
|
|
10.
|
Support Printing attributes: page size, orientation, margins, header, footer, page breaks...
|
|
|
11.
|
Exporting Workbooks, Worksheets, and selected ranges to HTML, RTF, CSV, and TSV files, including HTML table fragments for preview or email workflows.
|
|
|
12.
|
Exporting Database tables or DBGrid to Excel, HTML or RTF files
|
|
Advantages
|
1.
|
High performance and Low memory and CPU usage.
|
|
2.
|
Easy migration from OLE-based projects to our HotXLS solution.
|
|
3.
|
Easy to use.
|