Re: [libreoffice-users] How to convert tab-separated file to XLS from the command line

Hi :)
I think the MS 95 format is still .xls and can be read and used by subsequent versions of both MSO 
and all versions of LO.  So i think just don't worry about your 2nd point.  

LibreOffice can read/write tsv as well as csv but it's just not the default.  I'm not sure how to 
force it to change from csv to tsv on the command-line.

Apols and regards from
Tom :)  





> ________________________________
> From: Brian Cottingham <spiffytech@gmail.com>
> To: users@global.libreoffice.org 
> Sent: Wednesday, 13 February 2013, 18:41
> Subject: [libreoffice-users] How to convert tab-separated file to XLS from the command line
>
> I have a tab-separated file that I'm trying to convert to XLS from the
> command line. This is the command I'm using:
>
>     sudo libreoffice --headless --convert-to xls filename.tsv
>
> This has two problems:
>
>    1. LibreOffice does not use a tab separator; it assumes a comma
>    separator, so my columns aren't detected correctly
>    2. LibreOffice reports converting to MS Excel 5.0/95 format. How can I
>    instruct it to convert to Excel 2003 format?
>
> -- 
> For unsubscribe instructions e-mail to: users+help@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
-- 
For unsubscribe instructions e-mail to: users+help@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