Can't open xml about corexlsx HOT 8 CLOSED

failed in this method Archive . scanForEndOfCentralDirectoryRecord
return nil
if potentialDirectoryEndTag == UInt32(endOfCentralDirectoryStructSignature) {
not true for any trying

from corexlsx.

Hi @EvGeniyLell, sorry for the delayed reply. Unfortunately, I wouldn't be able to fully diagnose the issue without having access to this file. If you run unzip in command-line on it, does that succeed? What's the extension of the file, is that .xlsx or .xls?

from corexlsx.

https://www.icloud.com/iclouddrive/0eTaGEZfTKXR07NFeJPfy3tHw#Account_test_19.09.01-19.10

from corexlsx.

Hi @EvGeniyLell, this file is saved in an old proprietary binary file format called Excel Binary File Format. This can also be easily determined from the .xls extension. The file format that CoreXLSX is able to parse is .xlsx, which is the new open format Office Open XML.

from corexlsx.

@MaxDesiatov you think with the help of your KIT it will be impossible to parse this file

from corexlsx.

@EvGeniyLell an .xls file as is can't be parsed by CoreXLSX as this is a completely different undocumented format. On the other hand, any version of Office newer than 2007 should allow saving .xls files as .xlsx, I think this should be applicable to Numbers and Google Sheets too. Some loss of formatting data could be possible when you save it as .xlsx format, but that all depends on tools you'd use for conversion. I assume Office would be much better at this than anything else.

When you convert your file to .xlsx, parsing it with CoreXLSX should work, please let me know otherwise.

from corexlsx.

Sorry, but I am doing automation for this and I need to convert it to CSV
that's why I started looking for a POD that could convert XLS
Thanks for the clarification

from corexlsx.

If you're interested in parsing the old format directly, you could try using something like libxls.

from corexlsx.