Can't open xml

[EvGeniyLell]

I download xml from bank and I want convert it to csv
I try last version CoreXLSX, but I can't open file
(numbers and Microsoft excel already can open this file)
is can be opened file like this format, by CoreXLSX?

[EvGeniyLell]

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

[MaxDesiatov]

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?

[EvGeniyLell]

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

[MaxDesiatov]

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.

[EvGeniyLell]

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

[MaxDesiatov]

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

[EvGeniyLell]

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

[MaxDesiatov]

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