Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.os.linux.misc > #14533

Re: Converting .xlsx to .csv?

From Jeroen Belleman <jeroen@nospam.please>
Newsgroups comp.os.linux.misc
Subject Re: Converting .xlsx to .csv?
Date 2015-04-14 08:31 +0200
Organization Aioe.org NNTP Server
Message-ID <mgic8s$vkh$1@speranza.aioe.org> (permalink)
References (2 earlier) <Z9KdnSWyRrX6N7TInZ2dnUU7-W-dnZ2d@giganews.com> <mgcnrg$ocv$1@dont-email.me> <0s-dnYPfEOyMabTInZ2dnUU7-f-dnZ2d@giganews.com> <mggf7b$t32$1@dont-email.me> <otOdnZGRBM62frbInZ2dnUU7-UednZ2d@giganews.com>

Show all headers | View raw

On 2015-04-13 17:39, Robert Heller wrote:
> At Mon, 13 Apr 2015 09:11:00 -0400 Dan Espen <despen@verizon.net> wrote:
>
>>
>> Robert Heller <heller@deepsoft.com> writes:
>>
>>> At Sat, 11 Apr 2015 23:13:45 -0400 Dan Espen <despen@verizon.net> wrote:
>>>
>>>>
>>>> Robert Heller <heller@deepsoft.com> writes:
>>>>
>>>>> At Sat, 11 Apr 2015 16:27:32 -0400 Andreas Kohlbach <apr15.7.ankman@spamgourmet.net> wrote:
>>>>>
>>>>>>
>>>>>> Robert Heller wrote on 11. April 2015:
>>>>>>>
>>>>>>> Does there exist a *CLI* program to convert .xlsx files to .csv files?
>>>>>>>
>>>>>>> There are not any formulas or macros or anything like that in the files in
>>>>>>> question.
>>>>>>>
>>>>>>> *I* don't have OpenOffice or LibreOffice installed on my Linux machine.  *I*
>>>>>>> don't use <mumble>Office programs.  I know I can isntall OpenOffice but it is
>>>>>>> a beast that I am clueless about using, since I don't use it and don't really
>>>>>>> know how to use it and have never in my 45 years of computer programming -- I
>>>>>>> just don't deal with things that way.
>>>>>>>
>>>>>>> If there isn't a simple CLI program to do this, is there any documentation on
>>>>>>> the format of the file that I can use to write such a program?
>>>>>>
>>>>>> Is xlsx somewhat like xls (MS Excel Spreadsheet format)? Although
>>>>>> LibreOffice should be able to convert it. It might be even possible to
>>>>>> run it via command line. But I never dealt with that.
>>>>>
>>>>> LibreOffice is NOT a CLI program.
>>>>
>>>> Really?
>>>>
>>>> These folks seem to think it is:
>>>>
>>>> http://askubuntu.com/questions/379416/saving-xls-as-csv-with-libreoffice-calc
>>>>
>>>> One poster suggests:
>>>>
>>>> libreoffice --headless --convert-to csv --outdir somedir *.xls
>>>>
>>>> Yep, just ran a quick test, looks fine to me.
>>>
>>> It is a huge beast of a program.  Is there no small, simple utility?  I can't
>>> instal LibreOffice under CentOS 5 -- OpenOffice 3.1.1 is available for CentOS
>>> 5.  Why must I install 350meg of software for such a simple operation?  Talk
>>> about *extreme* bloat.  It appears that OO/LO are the most bloated software
>>> ever.
>>
>> You don't have any idea how much of LibreOffice gets loaded into memory
>> to accomplish '--convert-to csv'.
>
> I don't really care about memory usage.  My *main* issue with *Office software
> is the about of *disk* space they take up.
>
>>
>>> The --headless option does not work with OpenOffice 3.1.1 -- I have part of it
>>> installed on my desktop machine, where it *wastes* about 350meg of disk space
>>> -- I *never* use it and only have it so I can deal with occassional files
>>> people send me who are unable or unwilling to send as pdf or some other
>>> *standard* portable (and in my mind, usable) formats.
>>
>> You don't seem to be interested in a solution unless it fits your
>> arbitrary criteria.
>
> Well yes.  Why should I be interested in a solution that does not fit my
> criteria?
>
>>
>> OpenOffice 3.1.1 probably has it's equivalent of "--headless".
>> But that's probably not small and simple either.
>
>

At some point I tried to create web pages from data stored as
Excel files. This never came to anything, but in the process,
I came across Perl code that included a 'tocsv.pl' program.

Google for Spreadsheet-ParseExcel. That should bring up something.

Jeroen Belleman

Back to comp.os.linux.misc | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 14:48 -0500
  Re: Converting .xlsx to .csv? Bit Twister <BitTwister@mouse-potato.com> - 2015-04-11 20:04 +0000
  Re: Converting .xlsx to .csv? The Natural Philosopher <tnp@invalid.invalid> - 2015-04-11 21:16 +0100
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 18:12 -0500
  Re: Converting .xlsx to .csv? Andreas Kohlbach <apr15.7.ankman@spamgourmet.net> - 2015-04-11 16:27 -0400
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 18:12 -0500
      Re: Converting .xlsx to .csv? Dan Espen <despen@verizon.net> - 2015-04-11 23:13 -0400
        Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 23:26 -0500
          Re: Converting .xlsx to .csv? Dan Espen <despen@verizon.net> - 2015-04-13 09:11 -0400
            Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-13 10:39 -0500
              Re: Converting .xlsx to .csv? Jeroen Belleman <jeroen@nospam.please> - 2015-04-14 08:31 +0200
  Re: Converting .xlsx to .csv? Bobbie Sellers <bliss-sf4ever@dslextreme.com> - 2015-04-11 14:02 -0700
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 18:12 -0500
      Re: Converting .xlsx to .csv? Bill Marcum <bill.marcum57@gmail.com> - 2015-04-11 21:10 -0400
        Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 20:44 -0500
        Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 20:44 -0500
          Re: Converting .xlsx to .csv? John Hasler <jhasler@newsguy.com> - 2015-04-12 07:38 -0500
            Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-12 09:27 -0500
  Re: Converting .xlsx to .csv? Ken Sims <ng12207@kensims.#nospam#.net.invalid> - 2015-04-11 17:29 -0700
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 20:27 -0500
  Re: Converting .xlsx to .csv? Chick Tower <c.tower@deadspam.com> - 2015-04-12 03:24 +0000
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-11 23:26 -0500
      Re: Converting .xlsx to .csv? Chick Tower <c.tower@deadspam.com> - 2015-04-13 00:51 +0000
        Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-12 21:15 -0500
          Re: Converting .xlsx to .csv? "John F" <j@j.ii> - 2015-04-13 14:11 -0700
          Re: Converting .xlsx to .csv? Chick Tower <c.tower@deadspam.com> - 2015-04-14 18:30 +0000
            Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-14 14:51 -0500
  Re: Converting .xlsx to .csv? dillinger <dillinger@invalid.not> - 2015-04-12 23:42 +0200
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-12 18:57 -0500
      Re: Converting .xlsx to .csv? dillinger <dillinger@invalid.not> - 2015-04-13 18:26 +0200
        Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-13 12:09 -0500
          Re: Converting .xlsx to .csv? Stan Bischof <stan@worldbadminton.com> - 2015-04-17 19:38 +0000
    Re: Converting .xlsx to .csv? Robert Heller <heller@deepsoft.com> - 2015-04-12 18:57 -0500
  Re: Converting .xlsx to .csv? ray carter <ray@zianet.com> - 2015-04-12 22:49 +0000
    Re: Converting .xlsx to .csv? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2015-04-12 18:57 -0400

csiph-web