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

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?
-- 
Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, Kilburn 
Building | The University of Manchester | Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 
0039
-- 
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