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

http://mooedit.sourceforge.net/
allow to "save as" changing the codage.


Je la 28/08/2017 19:21, A skribis :
> 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