NativeExcel suite v3.x

Overview

NativeExcel v3.x is a high-performance solution for Delphi Developers that allows writing of new Excel spreadsheets and reading of existing ones.
A key feature of this version of NativeExcel is support for XLSX file format (Excel 2007/2010 file format).
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, XE, XE2, XE3 and XE4.
With NativeExcel v3.x you can open and modify an existing spreadsheet.

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

Advantages

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

Important notice

The current implementation for XLSX file format has some temporary limitations
The following features are not supported:
Any kind of graphic objects (images, notes, graphs, buttons etc.)
External references in formulas (references to external workbooks)
Data validation
Autofilters
We are going to add support for all these features in the near future.
Copyright © NikaSoft 2004-2013