public inbox for blinux-list@redhat.com
 help / color / mirror / Atom feed
* Reading Excel Documents under Linux
@  Martin G. McCormick
   ` Gil Andre
                   ` (2 more replies)
  0 siblings, 3 replies; 23+ messages in thread
From: Martin G. McCormick @  UTC (permalink / raw)
  To: blinux-list

	Is there any non graphical utility in Linux or UNIX that
will read Excel documents?  I run up against one of these about
twice a year or so on a very irregular basis.  It is possible to
use the strings utility on the binary and at least tell what it
is about, but it totally destroys any formatting and only serves
to satisfy my curiosity as to what words, etc were in there.
It's a really dirty way to access it so I am asking if there is
anything better or if anybody who can tell me about it knows the
format of an Excel document.  If I need to write such a utility,
I would love to make it freely available so others can use it so
I don't want to go the non disclosure route at all.

Martin McCormick




^ permalink raw reply	[flat|nested] 23+ messages in thread
* Re: Reading Excel Documents under Linux
@  Jennifer E Jobst
   ` Janina Sajka
  0 siblings, 1 reply; 23+ messages in thread
From: Jennifer E Jobst @  UTC (permalink / raw)
  To: blinux-list

I believe you can save or export Excel files as CSV (comma separated value)
files. This dumps to a flat text file where each value in a row is
separated by a comma, and rows are separated by carriage returns (e.g. each
row starts on a new line).

Of course, you have to get someone with Excel to save the file in CSV
format in the first place, which may be more trouble than it's worth. :(

Best of luck!

-j

Jennifer E. Jobst
Linux Information Development
IBM Linux Technology Services
(512) 838-8298, T/L 678-8298



                                                                                                                        
                    Gil Andre                                                                                           
                    <gandre@arkeia.com       To:     blinux-list@redhat.com                                             
                    >                        cc:                                                                        
                    Sent by:                 Subject:     Re: Reading Excel Documents under Linux                       
                    blinux-list-admin@                                                                                  
                    redhat.com                                                                                          
                                                                                                                        
                                                                                                                        
                    01/10/2002 11:51                                                                                    
                    AM                                                                                                  
                    Please respond to                                                                                   
                    blinux-list                                                                                         
                                                                                                                        
                                                                                                                        




This is the GNU solution you probably want.

http://www.xlhtml.org/

This utility converts Excel files into HTML file.

If you chain utilities, you should be able to convert Excel
files to HTML then to ASCII or some other format. Or you
could open it under lynx or some other apps.

Hope this helps!

On Thu, 10 Jan 2002 11:35:19 -0600
"Martin G. McCormick" <martin@dc.cis.okstate.edu> wrote:

>          Is there any non graphical utility in Linux or UNIX that
> will read Excel documents?  I run up against one of these about
> twice a year or so on a very irregular basis.  It is possible to
> use the strings utility on the binary and at least tell what it
> is about, but it totally destroys any formatting and only serves
> to satisfy my curiosity as to what words, etc were in there.
> It's a really dirty way to access it so I am asking if there is
> anything better or if anybody who can tell me about it knows the
> format of an Excel document.  If I need to write such a utility,
> I would love to make it freely available so others can use it so
> I don't want to go the non disclosure route at all.
>
> Martin McCormick


/----------------------------------------------------\
| Gil Andre -- Technical Writer -- gandre@arkeia.com |
|        Knox Software: http://www.arkeia.com        |
|A bug in the code is worth two in the documentation.|
\----------------------------------------------------/



_______________________________________________
Blinux-list mailing list
Blinux-list@redhat.com
https://listman.redhat.com/mailman/listinfo/blinux-list






^ permalink raw reply	[flat|nested] 23+ messages in thread
* Re: Reading Excel Documents under Linux
@  Martin G. McCormick
   ` John J. Boyer
  0 siblings, 1 reply; 23+ messages in thread
From: Martin G. McCormick @  UTC (permalink / raw)
  To: blinux-list

	I got it and it works!  I installed it with not so much
as a whimper on a Freebsd system and also on a Debian Linux
system.  There are a number of options in running it and I have
not done much other than verify that it took a .xls binary and
produced a perfectly good html document that lynx read with no
trouble.

	My thanks to Gil and to others who have responded.  If I
had to edit and handle Excel documents every day, I would
probably have to use a JAWS work station, but right now, these
things show up just often enough to be annoying.  I am sure glad
to be able to read them now and I will have to play with the
options to see what all I can do.

Martin

Gil Andre writes:
>
>This is the GNU solution you probably want.
>
>http://www.xlhtml.org/




^ permalink raw reply	[flat|nested] 23+ messages in thread

end of thread, other threads:[~ UTC | newest]

Thread overview: 23+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
 Reading Excel Documents under Linux Martin G. McCormick
 ` Gil Andre
 ` Janina Sajka
 ` Jude DaShiell
   ` Georgina
 Jennifer E Jobst
 ` Janina Sajka
   ` Dave Mielke
     ` Janina Sajka
       ` Dave Mielke
         ` Janina Sajka
       ` Angelo Sonnesso
 Martin G. McCormick
 ` John J. Boyer
   ` Henry Yen
   ` Dave Mielke
     ` John J. Boyer
       ` Dave Mielke
     ` Janina Sajka
   ` Gil Andre
   ` Janina Sajka
   ` Jude DaShiell
     ` Charles McCathieNevile

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).