OExport allows you to generate and read XLSX, XLS, ODS and CSV spreadsheets directly from Delphi & Lazarus. It has also an import feature - you can extract data from XLSX, XLS, ODS and CSV files. Please see the feature matrix below for more details.

Why is OExport the best solution for you:
You can create and read XLSX, XLS, ODS and CSV documents with just one code.
A wide range of compilers and platforms is supported:
Delphi 5, 6, 7, 2005, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1, 10.2, 10.3: Win32, Win64, Mac OSX (not iOS, Android, Linux); VCL and FireMonkey
Lazarus: Win32, Win64, Mac OSX, Linux (Little-Endian platforms only); LCL
File types are detected automatically.
Easy localization to your language. Languages included: English, Czech, German, Danish, French, Hungarian, Netherlands, Russian
Formula recalculation engine, see http://www.kluug.at/oexport-help/formula-recalculation-engine/ for details.
Template engine: automatically process user-defined XLSX/XLS templates.

Library design
Native pascal object oriented code
No external dll libraries are required
No dependency on Excel or Calc installation (no OLE)
Full unicode support even for non-unicode Delphi versions (D7, D2007 etc.)
Write-On-The-Fly and Read-On-The-Fly: export and import huge tables without the need to store the whole document in memory.
Reasonably fast (see performance table below).
Officially supported platforms
Delphi 5, 6, 7, 2005, 2006, 2007: VCL + full unicode support thanks to WideString.
Delphi 2009, 2010, XE: VCL
Delphi XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin: VCL + FireMonkey, 32bit + 64bit Windows, Mac OSX.
Important notice: Delphi ARM compiler (iOS) was not tested yet and may be unsupported.
Lazarus 1.0.8: 32bit + 64bit Windows, Linux and Mac OSX (XLS: Little Endian platforms only)
Template Engine
Currently only loading of XLSX/XLTX and XLS/XLT templates is supported.
Automatically replace cell values and modify cells.
Automatically add and process rows as they are defined in the template.
Save the generated template in all formats OExport supports: XLSX/ODS/XLS/CSV!
Feature Overview
See the following files for a fast feature overview. These files have been directly exported with OExport:

XLSX: oexport-fulldemo.xlsx
ODS: oexport-fulldemo.ods
XLS: oexport-fulldemo.xls
You can generate those files with the demo application you find in the FREE package (see download tab). They have not been edited after the export in any way.
Please note that XLS exporter doesn't support images and charts and therefore you won't see them in the exported XLS file.
The full source code that was used to generate them can be obtained from the documentation.

Only for V.I.P