OExport - XLSX/XLS/ODS/CSV native Delphi/Lazarus import/export library

Latest Version

2.19 (2014/07/11)

Basic info

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 and Lazarus; Win32, Win64, Mac OSX, Linux (Little-Endian platforms only); VCL, FireMonkey, LCL.
  • File types are detected automatically.
  • Easy localization to your language.
  • Formula recalculation engine, see http://www.kluug.at/oexport-help/formula-recalculation-engine/ for details.
  • Template engine: automatically process user-defined XLSX/XLS templates.

The documentation is online: http://www.kluug.at/oexport-help/.
You find an offline copy of the documentation here: oexport-help-offline.zip.

Features

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 5: you have to buy and install ZipForge as well because Abbrevia is not available for D5.
  • Delphi 2009, 2010, XE: VCL
  • Delphi XE2, XE3, XE4, XE5, XE6: 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:

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.

Feature Matrix

yes= Supported;yes= Partially supported; no= Not supported;n/a= Not available
Feature ExportImport
XLSX ODS XLS CSV XLSX ODS XLS CSV
Cell types: string, number, percent, currency, scientific, fraction, time, date, datetime yesyesyesyesyesyesyesyes
Rich text in cells yesyesyesn/ayesyesyesn/a
Custom number format yesyesyesn/ayesyesyesn/a
Hyperlinks for string cells yesyesyesn/ayesnoyesn/a
Formulas for all cell types yesyesyesyesyesyesyesn/a
Cell, row, column and worksheet formatting: horizontal + vertical alignment, wrap text, font, background color, borders (color, size and style), text orientation and rotation yesyesyesn/ayesnoyesn/a
Column widths + row heights yesyesyesn/ayesnoyesn/a
Column + row grouping yesyesyesn/ayesnoyesn/a
Conditional formatting yesyesyesn/ayesnoyesn/a
Column + row span (merged cells) yesyesyesn/ayesnoyesn/a
Print settings: page header & footer, page orientation, page margins, page order, page breaks, print scale, table centering, repeat columns & rows, grid lines, table headers yesyesyesn/ayesnoyesn/a
Fixed cells (window fixed scrolling) yesyesyesn/ayesnoyesn/a
Named cells yesyesyesn/ayesnoyesn/a
Cell & worksheet protection: with and without password yesyesyesn/ayesnoyesn/a
Autofilter yesyesnon/ayesnonon/a
Comments yesyesnon/ayesnonon/a
Images: JPEG, PNG, GIF, TIFF
 + fill, border, shadow
yesyesnon/ayesnonon/a
Charts: bars, columns, lines, areas, bubble, scatter; different line, fill, marker and axes styles, sizes, colors; titles ... yesyesnon/anononon/a

Row and column limits

OExport is able to read and write the maximum permitted row and column counts of every supported format.
The limits are the following:
Row countColumn count
XLSX1'048'57616'384
ODS1'048'5761'024
XLS65'536256
CSV2'147'483'6472'147'483'647

Performance

The performance of OExport may vary on used compiler. The best figures are reached with Delphi 2009 and newer.
The following times were measured on an old laptop from 2007 (Intel Core 2 Duo, 1.8 GHz, 4.0 GB RAM, Win 7 32bit). Files consisted of 1 million string cells with shared strings table (SST) either off or on.
1 million string cells ExportImport
XLSX ODS XLS CSV XLSX ODS XLS CSV
D2009+SST off 35 s32 s22 s15 s70 s84 s8 s15 s
SST on 44 s32 s27 s15 s105 s84 s9 s15 s
D5-D2007SST off 92 s75 s44 s42 s178 s170 s17 s32 s
SST on 100 s75 s50 s42 s260 s170 s20 s32 s
LazarusSST off 50 s48 s37 s29 s94 s103 s8 s26 s
SST on 55 s48 s40 s29 s124 s103 s8 s26 s

OFiller

  • OFiller: fill DOCX (Word 2007-2013), ODT (OpenOffice Writer), XLSX (Excel 2007-2013), XLS (Excel 97-XP), ODS (OpenOffice Calc) templates

Screenshots

Features of OExport

Template 1 and generated  XLS document Template 2 and generated ODS document XLSX real-world example (Excel 2007) ODS real-world example (OpenOffice) Export to ODS (LibreOffice) Export to XLSX (Excel 2007) Import from XLSX (Excel 2007) Export Tables with ColSpan and Formula All supported cell types Page header and footer are supported - even with special tags like "Page Number", "Page Count" etc.! XLSX: Image and a pie chart (Excel 2007) ODS: Image and a pie chart (OpenOffice)

OExport on different operating systems

Lazarus demo application Lazarus under Kubuntu - export to ODS Lazarus under Kubuntu - import from XLSX FireMonkey under Mac OSX - export to ODS FireMonkey under Mac OSX - import from XLSX Lazarus under Mac OSX - export to XLSX Lazarus under Mac OSX - import from ODS

OFiller

Fill DOCX Templates (Word 2007)

License

OEXPORT LICENSE INFORMATION
===========================


Copyright (C) 2011-2014 Ondrej Pokorny
  http://www.kluug.net

This license is applicable to all files distributed in this archive if not
stated differently.


*** BEGIN LICENSE BLOCK *****

OExport 2.x LICENCE
-------------------

 1) You may use OExport if:
     a. You use the FREE version.

        OR

     b. You buy a commercial license of the FULL version.

 2) Limitations of the FREE version
     a. There are no limitation per workplace. You can use OExport FREE
        both for commercial and non-commercial purposes.

     b. Only the first worksheet will be exported or imported and a maximum
        of 40 rows and 10 columns.

     c. You may not modify, decompile, disassemble, reverse engineer or
        translate OExport FREE.

 3) Limitations of the FULL version
     a. Single developer license: only the license holder may use OExport.

     b. 2-3 developers license: only maximum of 3 developers within the license
        holder company may use OExport.

     c. 4-5 developers license: only maximum of 5 developers within the license
        holder company may use OExport.

     d. Company license: all developers within the license holder company may use
        OExport.

     e. Licenses may not be sold or transfered to other developers or companies.

     f. There are no limitations in functionality in the FULL version.

     g. You get 2 years of free updates and new releases, starting from the day
        of purchase. After this period you can order extra 2 years of updates
        for 60% of the license price.

 4) You may NOT use OExport for:
     a. Writing libraries and applications that allow other applications to
        make use of OExport functions. An example would be to build an XLSX-
        ODS- or XLS-Export DLL library that uses OExport.

 5) Redistribution of the source code and the DCU's
     a. OExport source code and DCU's may not be redistributed on any kind
        of media and offered for download on any internet server without my
        explicit permission. They also may not be reselled.

 6) Redistribution in binary form
     a. If you haven't bought a commercial license, you have to attribute
        OExport in e.g. the About-Dialog of your software.
        The attribution must contain the name ("OExport") and my homepage
        ("http://www.kluug.net").

     b. If you have bought a commercial license, no attribution is required.

 7) Additional software licensed with OExport
     a. If you purchase OExport, you also get an OXml commercial license
        for the same time period you bought OExport updates for (i.e. you may
        use all OXml updates within 2 years after OExport purchase).

 8) Limited Warranty
     a. THIS SOFTWARE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
        EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
        WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
        THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS
        WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF
        ALL NECESSARY SERVICING, REPAIR OR CORRECTION. IN NO EVENT SHALL
        KLUUG.NET OR ANY OTHER PARTY WHO MAY HAVE DISTRIBUTED THE SOFTWARE AS
        PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL,
        SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR
        INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA
        OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD
        PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER
        PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE
        POSSIBILITY OF SUCH DAMAGES.


***** END LICENSE BLOCK *****

Commercial license

All commercial licenses include full source code of OExport that can be used on all officially supported platforms.

If you purchase OExport, you also get an OXml commercial license for the same time period you bought OExport updates for (i.e. you may use all OXml updates within 2 years after OExport purchase).

You may order a roality-free commercial license for a specified number of developers using OExport in your company. A commercial license allows you to use OExport in any kind of application commercial or freeware that does not break the Section 4. of the license ("DLL library").

You also get 2 years free updates and new releases with priority email support.
With these resources you can add XLSX/ODS support to your applications quickly and with ease.

Go to OExport online help.

Pricing & Order

Online orders are managed by PayPal. I also accept bank transfers to my bank account. In this case, please send me an email with your billing address and I send you my account number.

You receive an invoice per email after your payment.

All prices are without VAT.

I offer you a 30-days money-back guarantee if you can't use OExport for what is advertised on this page (because of bugs, compatibility problems etc.).

Commercial licenses & help access

OExport+OXml
for 1 developer
EUR 99,- (~ USD 135,-)
OExport+OXml
for max. 3 developers within one company
EUR 199,- (~ USD 275,-)
OExport+OXml
for max. 5 developers within one company
EUR 299,- (~ USD 413,-)
OExport+OXml
for unlimited developers within one company
EUR 399,- (~ USD 550,-)

Change log

OEXPORT RELEASE INFORMATION
===========================

  Version 2.18 (2014-04-09)

    New features
      + Delphi 5 support (you need to buy and install ZipForge because Abbrevia doesn't support D5)
      + Some bug fixes.

    Installation
      * If you want to update OExport, you have to install/update OXml as well (OXml is included in the zip package too).
        If you use packages, you have to recompile them! (Both OXml and OExport packages).


  Version 2.17 (2014-03-11)

    New features
      + XLSM support: add macro to an XLSX file from external XLSM template.
      + TExportCellStyle.Indent: indent of left/right alignment.
        See: http://www.kluug.at/oexport-help/export-classes/texportcellstyle/
      + TExportWindowSettings.Selection: active selection / active cell.
      + TExportWindowSettings.TopLeftCell: window scroll
        See: http://www.kluug.at/oexport-help/export-classes/texportwindowsettings/

    Installation
      * If you want to update OExport, you have to install/update OXml as well (OXml is included in the zip package too).
        If you use packages, you have to recompile them! (Both OXml and OExport packages).



  Version 2.16 (2014-02-11)

    Bug Fixes
      + Bux fix in TExportPageSettings.ScaleType, .FitWidthToPages, .FitHeightToPages

    Installation
      * If you want to update OExport, you have to install/update OXml as well (OXml is included in the zip package too).
        If you use packages, you have to recompile them! (Both OXml and OExport packages).



  Version 2.15 (2014-01-17)

    Bug Fixes
      + Some minor bug fixes

    New features
      + Back-end changed from OmniXML to OXml - the import performance should increase by about 20-30%
      + New property TOExport.UseProgress to easily disable the progress dialog
      + New properties TExportPageSettings.ScaleType, .FitWidthToPages, .FitHeightToPages

    Installation
      * If you want to update OExport, you have to install OXml as well (OXml is included in the zip package too).
        If you use packages, you have to recompile them! (Both OXml and OExport packages).



  Version 2.14 (2013-10-21)

    Bug Fixies
      + Some minor bug fixies
      + Performance optimalizations for non-unicode Delphi
      + Compatibility to OmniXML 1.19


    New features

      + Cell+worksheet protection
        http://www.kluug.at/oexport-help/export-classes/texportworksheetprotection/

      + Comments
        http://www.kluug.at/oexport-help/export-classes/texportcellcomment/

      + Added missing borders in XLSX/XLS
        http://www.kluug.at/oexport-help/export-classes/tcellborderstyle

      + Show grid lines and show headers (in document window)
        http://www.kluug.at/oexport-help/export-classes/texportwindowsettings/

    Installation
      * Please update OmniXML to 1.19 (the current version is included in
        OExport installation package).


  Version 2.13 (2013-08-19)

    Bug Fixies
      + Some minor bug fixies
      + Compatibility to OmniXML 1.17

    Installation
      * Please update OmniXML to 1.17 (the current version is included in
        OExport installation package).


  Version 2.12 (2013-07-01)
  
    Bug Fixies
      + white space handling corrected in XLSX/ODS files
      + bug in loading/saving rich text formatting in XLS/XLSX files
      + bug in autofilter of XLSX export (sorting of columns did not work)
      + XLS and XLSX can load/save dates in 1904 format (old Mac)
      
    !!!IMPORTANT CHANGE!!!
      + Global variables OExportDateFormat and OExportTimeFormat must be
        defined explicitely to reduce date/time formatting confusion.
        Please read more information in the documentation:
        http://www.kluug.at/oexport-help/global-variables/

    !!!IMPORTANT CHANGE!!!
      + TOExporterCSV renamed to TOExporterCSVComma:
        Now OExport uses 3 different CSV exporters (Comma, Semicolon,
        Excel-like). Please read the documentation:
        http://www.kluug.at/oexport-help/export-classes/tocustomexporter/toexportertext/
        
    New Features
      + XLT exporter (templates for Excel 97-2003)
        http://www.kluug.at/oexport-help/export-classes/tocustomexporter/toexporterxls/
        
      + XLTX exporter (templates for Excel 2007)
        http://www.kluug.at/oexport-help/export-classes/tocustomexporter/txlsxexporter/

    Installation
      * Please update OmniXML to 1.16 (the current version is included in
        OExport installation package).


  Version 2.11 (2013-05-27)

    Bug Fixies
      + CSV export: bug in function OFloatToFraction() fixed.

    New Features
      + Added TExportCellNumber.IntegerDigits property - support of
        zero-filled numbers (like 00000123).

      + Property TExportCellNumber.Format renamed to .DecimalPlaces.
        The .Format property was left for backwards compatibility.

      + New language constant OExportLNG_FileOldXLSBIFF5: is shown
        when the user tries to open the old BIFF5 (Excel 5.0/95)
        XLS file that OExport doesn't understand.

      + Rich text formatting support (import/export) with a RTF parser.
        See http://www.kluug.at/oexport-help/export-classes/texportcell/texportcellstring/
        for a demo.

      + OmniXML now supports NEXTGEN compilers (iOS).


  Version 2.10 (2013-05-02)

    Bug Fixies
      + Save dialog failed to show a warning about the file being overwritten
        when user hasn't defined file extension explicitely.

      + Column widths were not loaded correctly in some XLS documents.
      
      + CSV import bug: when a line did not end with a semicolon character,
        the first character of the next line was omitted.

    New Features
      + TExportRow, TExportColumn: Hidden property
      
      + Row and column grouping:
        + TExportRows.GroupRows, TExportRows.UnGroupRows
        + TExportCols.GroupCols, TExportCols.UnGroupCols
        + TExportRow.GroupLevel, TExportCol.GroupLevel
        http://www.mcstech.net/blog/index.cfm/2012/3/27/Grouping-Rows-in-Excel


  Version 2.9 (2013-04-10)

    Bug Fixies
      + Some XLS/XLSX documents could not be imported due to duplicate defined
        names.

      + Various export speed enhancements.

    New Features
      + On-the-fly import can now omit a worksheet from importing. Please note
        that the TExportAddWorkSheetEvent event has a new parameter
        aParseWorksheet.
        http://www.kluug.at/oexport-help/export-classes/texportaddworksheetevent/

    Installation
      * Please update OmniXML to 1.13 first:
        http://www.kluug.net/omnixml.php#download


  Version 2.8 (2013-03-23)

    Bug Fixies
      + Various range check errors corrected when range-checking enabled.
      
      + XLSX/XLS import/export improved
      
    New Features
      + Custom date/time formats
        http://www.kluug.at/oexport-help/export-classes/texportcell/texportcelldate/
        
      + Formula recalculation and XLS import/export supports now 43 functions.
        http://www.kluug.at/oexport-help/formula-recalculation-engine/
      
      + TExportCell.CalculateColWidth can be now used on multiple cells within
        one column.
        http://www.kluug.at/oexport-help/export-classes/texportcell/

    Installation
      * Please update OmniXML to 1.12 first: http://www.kluug.net/omnixml.php#download


  Version 2.7 (2013-03-12)

    New Features
      + XLS import added.

      + On-The-Fly Export: you can export sheets without the need to know the row count
        at the beginning of the export. You may also continue exporting the rows in a new
        sheet when the row count limit of the sheet was achieved.

    Features improved
      + XLSX import improved.

      + Column widths and row height are now double (instead of integer) for more precision.

    Installation

      * Please update OmniXML first: http://www.kluug.net/omnixml.php#download
      * Get the updated source code from: https://www.kluug.at/kluug-net/customerarea.php



  Version 2.6 (2013-02-22)

    New Features

      + Import of almost all XLSX features
            * styles, sizes, images ...
      + On-The-Fly Export and Import
            * Export and import huge tables without the need to store the whole document in memory.


      + Template Engine
            * Currently only loading of XLSX/XLTX templates is supported. XLS/XLT is in development.
            * 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!

      + OExport properties
            * TOExport.PageSettings.PrintHeaders: Boolean; print row and column headers
            * TOExport.PageSettings.PrintGridLines: Boolean; print grid lines
            * TOExport.WindowSettings.Autofilter: TExportRange; define autofilter on the table

    Modifications

      + OExport
            * TExportCell.Drawing removed and TExportCell.Drawings added:
              a cell can contain multiple images now
            * TExportDrawing.Fill moved to TExportCellDrawing.Fill
            * TExportDrawing.Shadow moved to TExportCellDrawing.Shadow
            * TExportDrawing.Border moved to TExportCellDrawing.Border
            * Excel can't save dates before 30.12.1890 -> TExportCellDate converts those dates
              automatically to string.

    Installation

      * Please update OmniXML first: http://www.kluug.net/omnixml.php#download
      * Get the updated source code from: https://www.kluug.at/kluug-net/customerarea.php



  Version 2.5 (2013-01-24)

    ! Bug fixies !
      + XLS exporter raised an error in Delphi 7 in specific
        circumstances

      + TExportWorkSheet.GetRealColCount and GetRealRowCount

      + TExportFont.Name handling bug

    ! Due to these bugs I recommend an update to all users of the 2.4 version !
    
    FEATURES MODIFIED
      + TExportFont.Style is now of type PExportFontStyle
        see http://www.kluug.at/oexport-help/export-classes/texportfontstyle/

        To make your old code compatible with OExport 2.5, you have to
        change:
          //xFont: TExportFont;
          xFont.Style := [fsBold];
        to:
          xFont.Style.AsFontStyles := [fsBold];

    NEW FEATURES
      + Styles of worksheets, rows and columns:
        - TExportWorkSheet.Style, TExportRow.Style, TExportCol.Style,
          TExportCell.Style
          http://www.kluug.at/oexport-help/export-classes/texportcellstyle/

      + More font style options (TExportFontStyle)
        http://www.kluug.at/oexport-help/export-classes/texportfontstyle/

      + Named cells and ranges (TOExport.NamedCells: TExportNamedCells)
        Named cells are also supported by the formula recalculation engine.
        http://www.kluug.at/oexport-help/export-classes/texportnamedcells/

      + Scientific cell type: TExportCellScientific
        http://www.kluug.at/oexport-help/export-classes/texportcell/texportcellnumber/
        
      + *Auto values (clAuto for colors, cahAuto for horizontal alignment,
        cavAuto for vertical alignment, ebAuto for border style)
        -> these values determine that the property is unset.
        -> Useful e.g. in conditional formatting (if you want to leave the
           background unchanged etc.)

    PLEASE SEE THE FULL DEMO FOR DEMONSTRATION CODE OF THE NEW FEATURES
      TABS ADDED:
      + "WS + Col + Row style"
      + "Named cells"
    SEE DEMO CODE:
      http://www.kluug.at/oexport-help/code-snippets/oexport-full-demo/



  Version 2.4 (2013-01-05)

    !!! You have to update OmniXML to version 1.9 !!!

    + Added support of XLS formulas and formula recalculation
      basic functions and operators only:
      + - * / ^, SUM, cells, ranges, constant numbers
      - demo code and full description:
        http://www.kluug.at/oexport-help/code-snippets/formulas/

    + Added support of XLS print settings (headers, margins, page breaks...)
      and fixed cells

    + Added new property TExportCellNumber.EmptyIfZero
      - set to True if you don't want to show the 0 value

    + Added support of conditional formatting
      - http://www.kluug.at/oexport-help/code-snippets/conditional-formatting/

    + Added support for editing already created cells:
      + TExportWorkSheet.FindRow, TExportWorkSheet.FindCreateRow
      + TExportWorkSheet.FindCell, TExportWorkSheet.FindCreateCell
      + TExportRow.FindCell, TExportRow.FindCreateCell
      + TExportCell.Transform
      - demo code:
        http://www.kluug.at/oexport-help/code-snippets/edit-created-cells/

    + FIXED BUG: in version 2.3 images and charts were sometimes misplaced!!!
    

  Version 2.3 (2012-12-10)
    + Delphi 6 support (source-code version only)

    - OExport modifications:
      + New property: TExportCell.CalculateColWidth for calculating cell width
        from text.
      + Speed optimalizations for non-unicode Delphi (6 - 2007)
      + No need to install TntUnicodeControls in non-unicode Delphi (6 - 2007)

    - OFiller modifications:
      + XLS (Excel 97-XP) files support

  Version 2.2 (2012-10-31)
    - Lazarus optimizations (no compiler warnings any more etc.)

    - OExport uses System.Zip in Delphi XE3 (no need to install TPAbbrevia)

    - Import reworked:
      o some CSV bugs fixed
      o some XLS bugs fixed
      o OExport can now import huge XLSX and ODS files (1'000'000 cells
        and more)

  Version 2.1 (2012-10-20)
    - IMPORTANT: You have to use OmniXML 1.6 or newer with OExport 2.1 !!!

    - Performance optimizations:
      o Memory usage issue: TExportFont, TExportCellBorder and TExportCellBorders
        are not classes any more, but records/objects. They are now returned as
        pointers (PExportFont, PExportCellBorder, PExportCellBorders).
        In Delphi you should be able to use your old source code. In Lazarus you
        will have to use the "^" operator for these types
        (f.e. xCell.Font^.Name := 'Arial').

    - New unit OExport_VclForms.pas:
      + This unit contains the TOExport.SaveToFileWithDialog method and a progress
        dialog that is shown automatically.
      + If you use OExport in a "normal" VCL Forms application, you have to add now
        3 units to your uses clause: OExport, OExport_Vcl, OExport_VclForms.
      + If you write a console application, web server or service application, you
        have to add only OExport, OExport_Vcl to your uses clause. These files
        don't use Dialogs and Forms units.
      + If you write a FireMonkey application, you have to add OExport, OExport_FMX
        to your uses clause.

  Version 2.0 (2012-10-10)
    - Features added
      + XLS support
      + CSV support
      + Global exporters + importers

    - Methods added (renamed)
      + Use TOExport.SaveTo* to export a document
      + Use TOExport.LoadFrom* to import a document
      o see documentation for details:
        http://www.kluug.at/oexport-help/export-classes/toexport/

    - Classes renamed
      o TXLSXExporter -> TOExporterXLSX
      o TODSExporter -> TOExporterODS

    - Classes removed
      - All exporters to files (TXLSXExporterFile*):
        use TOExport.SaveToFile* instead.

    Important notice: there is no need to use exporter classes directly
      any more. See demos at http://www.kluug.at/oexport-help/code-snippets/
      for demonstration code. The changes you have to make in your software
      are only very small.

  Version 1.0 (2012-06-28)
    - first public release of OExport 1.x


  Version 0.1 (2011-12-13)
    - first public release of OExport 0.x

Download

Please be sure you check the license information before downloading any of the files below.

OExport FREE/TRIAL package

OExport offline documentation

Installation

1.) Add OExport path to your library - please mind your Delphi version!

  For Delphi XE4 32bit, the path is:
    {INSTALLATION DIRECTORY}\OExport\DelphiXE4\Win32\

2.) Add OXml path to your library.

  The path is:
    {INSTALLATION DIRECTORY}\OXml\utils\

3.) Add Abbrevia path to your library. (Omit this step if
    you are using Delphi XE2 or newer).

  The path is:
    {INSTALLATION DIRECTORY}\Abbrevia\source\

4.) Run the demos from your Delphi IDE.

  You find the demos in:
    {INSTALLATION DIRECTORY}\OExport\demo\source\
    
5.) Run the compiled FULL demo

  You find the precompiled demo of the commercial full version in:
    {INSTALLATION DIRECTORY}\demo\compiled-fulldemo\

Important notice

The FREE/TRIAL package contains OXml and TPAbbrevia already. OXml is licensed under CPAL 1.0, TPAbbrevia under MPL 1.1.

Compiled applications without source code

Contact me for more information (you can write in czech/english/german/russian): Email