xlsxio_xlsx2csv not working on Chorus PRO XLSX files

[eblanpain]

I am a user of xlsxio_xlsx2csv which I like for its simplicity.

I use it for extracting .XLS files from a XLS governmental source.

Chorus is the service for electronic invoicing to French gvt.

This was working fine until recently when for an unknown reason, it stopped working.

a link to a current file is here:

https://communaute.chorus-pro.gouv.fr/annuaire-cpro/

If needed, I do keep some older file (2022?) on which your CLI software was working.

Hence, I am reporting this to you so that you may want to look into, if you have time

Cheers!

[brechtsanders]

I have not been able to see any crash when using the latest version of xlsxio_xlsx2csv on file AIFE-Chorus-Pro-Annuaire_20240319.xlsx downloaded from the link you supplied.

When you say it's not working, what exactly do you mean? Does it crash? Is the data wrong?

Which version were you using?

[eblanpain]

Thanks! I use -h to read the version number it says.Version: 0.2.21. Yet it is located in xlsxio-0.2.34-binary-win64\bin\xlsxio_xlsx2csv.exe

the XLSX has 2 sheets structures and Services. I use xlsxio_xlsx2csv from time to time, say once a week.

On earlier version of the file (say 2022) I could get 2 csv. Now,I only get one... The xlsxio_xlsx2csv does not crash, but does not see the second sheet as it used to do

using "C:...\xlsxio-0.2.34-binary-win64\bin\xlsxio_xlsx2csv.exe" "E:...\AIFE-Chorus-Pro-Annuaire_20240319.xlsx" Processing file: E:...\AIFE-Chorus-Pro-Annuaire_20240319.xlsx Sheet found: Structures, exporting to: E:...\AIFE-Chorus-Pro-Annuaire_20240319.xlsx.Structures.csv

Whereas Libreoffice does confirm that there should be a second sheet 'services', which it does not find Thanks for your help...

[brechtsanders]

Can you try again with the release I published yesterday?

[eblanpain]

By chance I had kept some older XLSX files from the same provider. recent files can be downloaded from the provider. Old AND new have 2 sheets (confirmed by LibreOffice)

Yet... With the Command Line:

Using version xlsxio-0.2.34-binary-win64 on an old source file (20221219) Sheet found: Structures, exporting to... Sheet found: Services, exporting to...

Using version xlsxio-0.2.34-binary-win64 on a newer source file (20240305) Sheet found: Structures, exporting to...

Using version xlsxio-0.2.35-binary-win64 on an old source file (20221219) Sheet found: Structures, exporting to... Sheet found: Services, exporting to...

Using version xlsxio-0.2.35-binary-win64 on a newer source file (20240305) Sheet found: Structures, exporting to...

[jc101b]

I just opened the problem.. xlsxio_xlsx2csv.exe does not convert xls spreadsheet. it does not lock..it simply exits without any message.

[brechtsanders]

You are right, the older .xls format won't import.

As the name imples XLSX I/O is only for .xlsx format.