Page 1 of 1

XLSX files generated by different spreadsheet applications

Posted: Fri May 22, 2015 10:56 am
by piro
Hi,

I meet the problem that different Spreadsheet applications generates different XLSX formats, which XLSReadWriteII 5 does not handle.
For example, if I generates an XLSX file using a XLSReadWriteII5 component and change it in any version of Microsoft Excel, I can reopen it with the component.
However, if I changed it LibreOffice or Googledocs (and export it to XLSX), the component would raise an error message: ZLib decompress error.

Is it a real problem with the component, or should I do something else in order to open these formats?

Thank you for your answer.

Attila Piros

Re: XLSX files generated by different spreadsheet applications

Posted: Mon May 25, 2015 7:00 am
by larsa
Hello

The problem is the ZIP lib (we have not written that). You can set: XLS.UseAlternateZip := True; This will use the ZIP lib that comes with delphi. Will usually work with openoffice files, but will not always work with excel files.