Re: [libreoffice-users] convert xlsx to CSV (and utf8?)

Thank you.  I may end up doing that, but I'm trying to avoid it. I 
picked one direction (before I knew about unoconv) and I want to see it 
through to the end.  It's supposed to work.  I may be forced to revisit 
this solution if all else fails.


On 08/28/2017 12:28 PM, Tony Arnold wrote:
> Have you looked at the 'unoconv' command? Specifically designed for
> conversion of office documents from one format to another.
>
> (I've come to the thread late, so apologies if this has already been
> suggested.)
>
> Regards,
> Tony.
>
> On Mon, 2017-08-28 at 10:21 -0700, A wrote:
> > Thank you for responding.  Yes it opens without issue.
> >
> > Yet another look at the conversion details made me notice I needed
> > changes.  Below are two incarnations.  For one thing I had left out
> > column formatting, which I guess is required?  No difference in any
> > event.
> >
> > apb@yellow:/usr/local/src/greetonix/src$
> > /usr/lib/libreoffice/program/soffice.bin
> > -env:UserInstallation=file:///tmp/libreoffice-1 --headless --
> > nolockcheck
> > --convert-to txt:Text \(encoded\):UTF8 --infilter=MS Excel
> > 97:44,34,76,1,1/2/2/2,1033,true,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.txt using filter : Text
> > Error: Please verify input parameters... (SfxBaseModel::impl_store
> > <file:///usr/local/src/greetonix/src/KGI_Discontinued.txt> failed:
> > 0xc10)
> >
> > Also tried:
> >
> > apb@yellow:/usr/local/src/greetonix/src$
> > /usr/lib/libreoffice/program/soffice.bin
> > -env:UserInstallation=file:///tmp/libreoffice_1 --infilter='MS Excel
> > 97:44,34,76,1,1/2/2/2,1033,true,false' --headless --nolockcheck
> > --convert-to 'csv:Text - txt - csv (StarCalc):44,34,76,1'
> > KGI_Discontinued.xlsx
> > *Error: source file could not be loaded*
> >
> > apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx
> > -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx
> >
> >
> > Which is an improvement, but not the solution.  All I really did was
> > rearrange the order of the parameters, change a hyphen to an
> > underscore
> > in the tmp file path and change double quotes to single quotes.  I
> > think
> > I recall reading somewhere that order matters so that's what likely
> > eliminated the "verify input parameters" message.  You may also
> > notice I
> > changed output from utf8 to csv. I need *both* utf8 & csv.
> >
> > Maybe I need yet another rearrangement to eliminate the file load
> > error?
> >
> > Thank you!
> >
> >
> >
> > On 08/27/2017 06:41 PM, James Knott wrote:
> > > On 08/27/2017 08:59 PM, A wrote:
> > > > 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$
> > > >
> > > > apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx
> > > >
> > > > -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx
> > > >
> > > > apb@yellow:/usr/local/src/greetonix/src$
> > > What happens if you just open the file in LibreOffice?


--
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