Standalone Excel to csv conversion?

sa212+lo at cyconix.com sa212+lo at cyconix.com
Fri Apr 29 17:03:05 UTC 2022


Thanks for the responses - if I can reply to everyone at once:

Joao - thanks, rows looks good, but I'm trying to move away from Python 
- I currently only need it for Excel handling

Kohei - yes, pretty much what I was expecting, thanks. Unfortunately, I 
do need xls, for at least another year or so. The C libs I've looked 
(briefly) at are:

xlnt (https://github.com/tfussell/xlnt) - looks good, but doesn't handle 
xls, and it's not obvious that it can yet export csv files

OpenXLSX (https://github.com/troldal/OpenXLSX) - doesn't seem as mature 
as xlnt; again, xlsx only, not obvious that it can export csv

Michael - good idea, at least in the short term. Both LibreOffice and 
ssconvert (gnumeric) can handle my test spreadsheets and generate csv 
output. I'm sticking with ssconvert at the moment, as I suspect that a 
gnumeric headless install is (much?) less resource intensive than a 
LibreOffice install and then running it headless (I need to run headless 
on a server). I've covered this on SO at 
https://serverfault.com/a/1099802/221197.

There are also other potential solutions - there are at least 3 program 
called xlsx2csv, for example. All 3 are minimally documented and 
probably don't work. I've tried the Python version, but can't persuade 
it to produce anything other than floating-point output for times.



More information about the LibreOffice mailing list