HotXLS Excel Read Write Library is a high-performance excel read-write library & component for Delphi & C++Builder, it can writing new Excel spreadsheets, as well as¹ reading and modifying existing Excel xls files without Excel installed.



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 6/7/2006/2007/2009/2010 and C++Builder 6/2006/2007/2009/2010.



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 coumpting.

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.