search

EticaAI / lexicographi-sine-finibus

Lexicographī sine fīnibus
The Unlicense
1 stars 1 forks source link

Bugs with type conversion when extracting data from complete XLSX with all index files for the Dictiōnāria #30

Closed fititnt closed 2 years ago

fititnt commented 2 years ago

Issue commented here https://github.com/EticaAI/multilingual-lexicography/issues/29#issuecomment-1101861298.

We need to explore some options to deal with this. It's annoying, and even if it works on short term, we may have bugs later with such extra zeroes. They were not an issue when getting data directly one by one from GSheets, but this obviously does not scale when working with dozens of sheets to automate processing.

fititnt commented 2 years ago

Humm, GNU ssconvert (because do not allow select the sheet, as per https://mail.gnome.org/archives/gnumeric-list/2006-September/msg00050.html, and also someone else trying here https://unix.stackexchange.com/questions/634393/how-can-i-convert-specific-sheets-in-an-xlsx-file-to-csv-via-the-linux-command-l) will not work in this case.