Re: [libreoffice-users] convert xlsx to CSV

2017-08-28 2:59 GMT+02:00 A <publicface@bak.rr.com>:

> 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: users+unsubscribe@global.libreoffice.org
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