Overview — NativeExcel suite
- What it is: A Delphi-focused library (from NikaSoft) for creating, reading and modifying Excel files natively without requiring Microsoft Excel or OLE automation.
- Main uses: Generate Excel reports, export datasets/DB grids to spreadsheets, read existing .xls files, and convert/export worksheets to HTML/RTF/CSV/TSV.
- Key features: cell-level access (numbers, strings, dates, formulas), formula recalculation engine, formatting (fonts, borders, fills), merged cells, images (bmp/jpg/png/emf/wmf), hyperlinks, comments, row/column grouping, printing/page setup, password‑protected file reading, Unicode support, copy/insert/delete ranges.
- Components: includes TDataset2Excel and TDBGrid2Excel for populating sheets from Delphi datasets/DBGrids.
- Performance: marketed as high-performance (tens of thousands of values/sec) and a replacement for OLE-based components.
- Platform & compatibility: Native Delphi source for Windows; versions historically target Delphi 4–2010 and older Windows platforms (check current docs for modern Delphi/.NET variants).
- Licensing / availability: Historically distributed as a trial with paid licensing; current versions and pricing vary by distributor—check the vendor page or download sites for the latest build (e.g., v2.8.x series).
- Alternatives: FlexCel (TMS), IronXL, HotXLS and other native Excel libraries for Delphi/.NET.
If you want, I can:
- show example Delphi code to create a workbook with NativeExcel suite (assuming v2.x), or
- fetch current download/documentation links and latest version details. Which do you prefer?
Leave a Reply