Again errors when opening Excel files

[chbeer]

There were problems opening Excel files with earlier versions.

Since I switched to the SPM version I got this error again:

Anybody else? In the past it was related to (SS)ZipArchive and/or a missing XML-node. Does somebody else have this?

[chbeer]

This also happens with the current CocoaPods version. I'm sure it was fixed 🤔

[shiva-menlo]

Any solution for this? Even i am getting this error.

.

[chbeer]

As far as I understand, the problem is coming from ZipArchive creating some kind of wrong ZIP. I „solved“ this issue by using an older version of ZipArchive.

[shiva-menlo]

Can you please let us know which ZipArchive version did you used?

[chbeer]

Sure, I cloned XlsxReaderWriter to change the dependency:
https://github.com/chbeer/XlsxReaderWriter.git / master branch

[shiva-menlo]

@chbeer , thank you for git url. I will update to this later.
as a hot fix I just changed below line in my pod file, i know it's going backwards but fixed for now.

pod 'SSZipArchive', '2.2'
pod 'XlsxReaderWriter', '2.4.1', :source => 'https://github.com/charlymr/XlsxReaderWriter-Podspecs.git''

[chbeer]

Yes, I did something like that as well. But we switched to SPM and that's not as easy to fix there.

[shiva-menlo]

OK @chbeer ,
Thank you for helping me out on this (Y)

[charlymr]

@chbeer @shiva-menlo I am trying to use an older version of ZipArchive. with 2.3.0 the Xlsx file open fine without error. Will try to push the update tomorrow.

[charlymr]

@chbeer @shiva-menlo the issue is fixed with version 2.5.0. https://github.com/charlymr/XlsxReaderWriter/releases/tag/2.5.0

The lib is no longer dependent of ZipArchive, so you can use it with either SPM, Cocoapods or Carthage.