Reference>Overview :: Delphi + Excel

NativeExcel v2.x is a high-performance solution for Delphi Developers that allows writing of new Excel spreadsheets and reading of existing ones.

NativeExcel is completely written in Object Pascal and does not require installed Microsoft Office, it writes and reads excel files directly.

NativeExcel can be used as a replacement of standard Excel components, it have the same object model, properties and methods.

NativeExcel works with Delphi 4,5,6,7,2005,2006,2007,2009,2010 and XE

With NativeExcel v2.x you can open and modify an existing spreadsheet.

If you need write-only to excel file feature, See: NativeExcel v1.x

Features

1.	Read an existing excel file
2.	Access any cell values (number, string, date, boolean, formula)
3.	Calculation engine which allows to obtain the result of formula
4.	Images support
5.	Cell attributes (alignment, orientation, comments, borders, background attributes, and so on)
6.	Font attributes (font name, font size, color, decoration, and so on)
7.	Merged cells
8.	Unicode characters support
9.	Defined names support
10.	Hyperlinks support
11.	Copy/Move/Delete/Insert range of cells
12.	Group rows and columns
13.	Worksheet attributes (name, protection, selection, outline, and so on)
14.	Reading of password protected (encrypted) excel files
15.	Printing attributes (page size, orientation, margins, footer, header, page breaks, and so on)
16.	Exporting workbooks and worksheets to HTML files.
17.	Exporting workbooks and worksheets to RTF files.
18.	Component TDataset2Excel for exporting TDataset descendants to Excel, HTML or RTF file
19.	Component TDBGrid2Excel for exporting TDBGrid to Excel, HTML or RTF file

1.	High performance
2.	Convenient object model
3.	Low memory and CPU usage
4.	Easy migration from OLE-based to our NativeExcel's objects. NativeExcel is developed to be compatible with standard Delphi's Excel components
5.	Source code is included in registered version
6.	Package is well documented and supplied with numerous examples