accessing excel-sheets from unix?

accessing excel-sheets from unix?

Post by Christopher Pay » Tue, 14 Nov 1995 04:00:00



: I'm looking for a solution to access excel-sheets (from Excel 4 or better  
: Excel 5) on a unix machine. It has to be possible to get some values out  
: of a spreadsheet to process them in an unix program.

I just save my Excel sheets as a CSV (Comma Separated Value) file.  It looks
so much like a text file, it's not funny.  Then I just write a quick program
that looks for commas, and do what I wish with that data.

C

============================================================================

Director of Research & Development  Cool: Anime, Atari, RPGs, M:tA
Hemlock Corporation                 WWW: http://www.rose-hulman.edu/~payneca
============================================================================

 
 
 

accessing excel-sheets from unix?

Post by Sauli Kar » Thu, 16 Nov 1995 04:00:00



Quote:>I just save my Excel sheets as a CSV (Comma Separated Value) file.  It looks
>so much like a text file, it's not funny.  Then I just write a quick program
>that looks for commas, and do what I wish with that data.

BTW, do you know about the opposite direction: Once I found that Excel takes tab-separated ascii files and puts them neatly in a sheet.

=========================================================================

Ericsson Telecom/Test Technics          Phone   : +358 0 299 2084            
02420 Jorvas/Finland                    Fax     : +358 0 299 2634
=========================================================================

 
 
 

accessing excel-sheets from unix?

Post by Rimon Ba » Thu, 16 Nov 1995 04:00:00


Quote:> >I just save my Excel sheets as a CSV (Comma Separated Value) file.  It looks
> >so much like a text file, it's not funny.  Then I just write a quick program
> >that looks for commas, and do what I wish with that data.

Be careful that you don't over-simplify, since the CSV format is not as
simple as you think.

Sure, all values are comma-separated and records end with a new-line. But
what if one of your values has a comma in it. Then the format for CSV
states that this text be enclosed within quotes.

Therefore:
1,2,3,4,"asdf,",asd

Is:
1   2   3   4   asdf,   asd

Also, escape characters are supported within the quotes via the standard
backslash method. (\13 for EOL, I think, etc...)

You may not need this complexity, but without it you risk data corruption.

Rimon.

  +---------------------------------+--------------------------------------+
  |                                 | Rimon Barr                           |
  |                                 | University of Toronto                |
  |    ---  __ o    __~o    __ o    |                                      |

  |    --- ( )/( ) ( )/( ) ( )/( )  | Web: http://www.cs.toronto.edu/~barr |
  |                                 |                                      |
  +---------------------------------+--------------------------------------+
  | The path of peace is preferable to the path of war.                    |
  |                                 -- Itzhak Rabin (01/03/22-04/11/95)    |
  +------------------------------------------------------------------------+

 
 
 

1. excel sheets on apache

Here's my problem:
We have on our intranet webserver (apache 1.3.1) site where one can access
certain excel sheets. Few of them are readable to all and few are readable
throug authentication. Now, those worldreadable can be accessed all the time
and it works fine. But the other ones can be accessed only now and then.
When there is no access excel "informs" with "Server error". Apache
access.log shows:
................................................................
192.205.41.49 - - [21/Oct/1998:13:40:54 +0300] "GET
/~foo/private/private_excel_sheet.xls HTTP/1.1" 401 413
....................................................

In Apache access.conf lines for private authentication:

<Directory /home/foo/public_html/private>
AuthName "Private stuff"
AuthType Basic
AuthUserFile /etc/apache/users
require user user
</Directory>

And all these excel files are updated though samba by some users.

This thing is driving me crazy!
Please, give me some pointers!

Thank You
Mika

2. Getting exit status for a command completed by rsh.

3. EXCEL,WORD,ACCESS... under UNIX

4. left handed mice?

5. automating the export of a unix file into excel or access?

6. rsh permission

7. EXCEL, WORD, ACCESS... under UNIX (ie X11)

8. F90 for Linux?

9. Wanted: Excel or Excel Like Freeware under LINUX

10. Accessing MS-Excel data in Linux

11. ** Finally - A UNIX Cheat Sheet! **

12. Wanted : viewer(s) allowing Unix & VMS users to view MS Word/Excel/PP ??

13. Would love UNIX program that could read Excel binary file...