Native Excel is a rapid and robust library for developers working in Delphi, which gives them the ease of working with Excel files. It does not need one to have Microsoft Office installed, as it can directly read and write Excel files, unlike many other tools. This makes it light, reliable, and suitable for processes where you need to deal with Excel spreadsheets on the fly.
NativeExcel is easy to use and familiar to use with its clean and intuitive object model. Existing Excel files can be opened quickly, new files can be created, and all the values and personal formatting can be managed by the developers. It also consists of standardized packages such as TDataset2Excel and TDBGrid2Excel that allow one to easily export the data in Delphi applications to Excel.
One of its best features is its performance - NativeExcel is capable of working with tens of thousands of values per second. Together with a feature that supports the use of advanced Excel functionality like formulas, images, password-protected files, and complete formatting capability, it gives you all the tools needed to create Excel-based solutions right within your Delphi applications.
Key Features of Native Excel:
- Open and create Excel files (XLS/XLSX): Work with both older and newer Excel formats without Microsoft Office.
- Read and write any cell values: Numbers, text, dates, booleans, and even formulas are fully supported.
- Calculation engine: Lets you perform computations on spreadsheet data automatically.
- Rich formatting tools: Customize alignment, borders, comments, background, and orientation for cells.
- Font styling: Adjust font type, size, color, and decorations like bold or italic.
- Image support: Insert common image formats (BMP, JPG, PNG, EMF, WMF) directly into spreadsheets.
- Merged cells and grouping: Combine cells or organize rows/columns for cleaner layouts.
- Unicode support: Handle international text and special characters easily.
- Range operations: Copy, move, insert, or delete blocks of cells quickly.
- Worksheet control: Manage names, protection, selections, and outlines.
- Printing options: Define page size, orientation, margins, headers, footers, and page breaks.
- Password-protected files: Open and work with encrypted Excel spreadsheets.
- Export tools: Save workbooks or worksheets to HTML, RTF, CSV, or TSV formats.
- Dataset/Grid integration: Use TDataset2Excel and TDBGrid2Excel to export Delphi data directly into Excel.
Click on the links below to Download the latest version of Native Excel Full Source!
