#1 2011-12-13 16:38:55

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+ wink

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

enjoy

Offline

#2 2011-12-13 17:21:00

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,609
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!

Offline

#3 2011-12-14 02:53:42

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.

Offline

#4 2011-12-14 08:16:08

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,609
Website

Re: oExport

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

Thanks for sharing your code!

Offline

#5 2013-05-27 06:40:14

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

Offline

Board footer

Powered by FluxBB