2017-08-28 2:59 GMT+02:00 A <[email protected]>: > I'm trying to convert a file from .xlsx to CSV. After googling until my > eyes were bleeding, the below is the best I could come up with. I've tried > various incarnations of the below this is just the latest. Any ideas > what's wrong here? The input file clearly exists. ubuntu 16.04 > LibreOffice 5.1.6.2 10m0(Build:2) > > Thank you in advance! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > apb@yellow:/usr/local/src/greetonix/src$ > /usr/lib/libreoffice/program/soffice.bin > -env:UserInstallation=file:///tmp/libreoffice-1 --headless --nolockcheck > --convert-to csv:Text \(encoded\):UTF8 --infilter=MS Excel > 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx > Error: source file could not be loaded > Error: source file could not be loaded > Error: source file could not be loaded > convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> > /usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text > Error: Please verify input parameters... (SfxBaseModel::impl_store > <file:///usr/local/src/greetonix/src/KGI_Discontinued.csv> failed: 0xc10) > apb@yellow:/usr/local/src/greetonix/src$ > > > Some things seems wrong on that command line:
- On most system you can directly call "libreoffice" instead of providing the full path - I'm not sure the -env:UserInstallation part is needed, unless you have some specific requirements - the \(encoded\):UTF8 part is not linked to anything, and thus is used as an input filename. This is most likely not what you want. - the --infilter might not be needed, as xlsx files should have enough informations about themselves to load properly. I was able to convert an xlsx to a csv in UTF-8 using the following simple command: $ libreoffice --headless --nolockcheck --convert-to csv --infilter=CSV:44,34,76,1 a.xlsx The "76" is responsible for generating an UTF-8 CSV output. If that is not one of your requirements, you can slim this down even more: $ libreoffice --headless --nolockcheck --convert-to csv a.xlsx And if your document isn't open by someone else at the same time, you can even remove the nolockcheck. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
