mORMot Open Source

reddwarf

Member

Registered: 2010-06-28

Posts: 40

Website

oExport

as I promised, I released oExport, my native Delphi2007 XLSX/ODS suite. it can import/export XLSX (Excel 2007) and ODS (OpenOffice Calc) files.
license is the same as SynPDF (MPL/GPL/LGPL tri-license)

(+) NATIVE: no external libraries or excel/calc installation needed.
(-) only Delphi 2007... but someone can help rewrite the code for D2007+

http://www.kluug.at/xlsx-ods-delphi.php

enjoy

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: oExport

Nice code!

I have the following error when I try to open the .ods file as generated in Excel 2007:

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error061080_01.xml</logFileName> 
  <summary>Errors were detected in file 'C:\Temp\_tc\doc\import-ods.ods'</summary> 
- <additionalInfo>
  <info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info> 
  </additionalInfo>
  </recoveryLog>

But the file is opened with success.

It is very nice to see useful Delphi code under MPL/GPL/LGPL tri-license!

reddwarf

Member

Registered: 2010-06-28

Posts: 40

Website

Re: oExport

this is a problem of Excel 2007, as the file "import-ods.ods" was created directly in LibreOffice and not by my code.

try to open "my-export.ods" - this is a file generated by my application. it can be opened without problems in my excel 2007.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: oExport

I'm not surprised that Excel did not support the OpenDocument format at 100%...

Thanks for sharing your code!

ebz

Member

Registered: 2011-07-20

Posts: 18

Re: oExport

Hi ab, can you add (integrate) new exporting engine (such what reddwarf said) that generate excel (xls or xlsx)? I've visit the oExport page, unfortunately it's now has different license.. I think it will great addition for this framework, as most client still prefer export as excel