XLSX files generated by different spreadsheet applications

[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

[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.