 |
HotXLS Excel Read/Write Library is a high-performance excel read-write component for Delphi & C++Builder, it can writing new Excel spreadsheets, as well as reading and modifying existing Excel xls files.
HotXLS is written in Object Pascal, it does not require Microsoft Excel /Office be installed, it reads and writes excel files directly. HotXLS works with Delphi and C++Builder XE5 through 13 Florence.
Classic XLS color formatting intentionally remains palette-based. See Classic XLS color model for the ThemeColor / TintAndShade decision.
|
Features
|
1.
|
Read existing excel file and write new or existing excel file, reading of password protected (encrypted) excel files.
|
|
|
2.
|
Access cell values, including number, string, date, boolean and formula.
|
 |
|
3.
|
Built-in calculation engine support formula computing.
|
|
|
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/color/decoration, support images.
|
|
|
7.
|
Support unicode characters, manipulate excel files written in any languages.
|
 |
|
8.
|
Support hyperlinks, support Excel defined names.
|
|
|
9.
|
Support Worksheet attributes: name, protection, selection, outline, and others.
|
|
|
10.
|
Support Printing attributes: page size, orientation, margins, header, footer, page breaks...
|
|
|
11.
|
Exporting Workbooks and Worksheets to HTML, RTF and CSV files.
|
|
|
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.
|