One other idea might be to use the ODBC package to get at
the data.

----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=----------
mailto:Ronald.P.Welch at baesystems.com                Phone:(607)770-3701
BAE SYSTEMS Controls            600 Main St Johnson City, NY 13790-1888
----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------


-----Original Message-----
From: Guenther Schmidt [mailto:gue.schmidt at web.de] 
Sent: Friday, June 18, 2004 5:43 PM
To: squeak-dev at lists.squeakfoundation.org
Subject: Re: Accessing Excel sheets


Hi,

Thank you all.

I had hoped there would be a way to access at least the data from the 
excel sheets directly via squeak without the need to convert the files 
first.

At this time I rather doubt I'd be able to write my own parser for excel 
sheets in squeak ;-). I had hoped somebody already had.

Anyway I reckon converting it into CSVs first is propably the most 
feasable option.

Squeak is very cool and it is far more consistent than anything I've 
tried sofar. (I had a go at Lisp, Scheme and .NET).

Günther


Kurt Thams wrote:
> FYI: You can generate a CSV text file, and if you give the filename
> extension ".xls", Excel will happily open it upon double-clicking.
> 
> Of course, if you use CSV you can only put data in the fields, not
formulae,
> and you can't do any formatting.
> 
> -- kurt
> 
> 
> 
>>-----Original Message-----
>>From: squeak-dev-bounces at lists.squeakfoundation.org
>>[mailto:squeak-dev-bounces at lists.squeakfoundation.org]On Behalf Of Ken
>>Causey
>>Sent: Friday, June 18, 2004 1:49 PM
>>To: The general-purpose Squeak developers list
>>Subject: Re: Accessing Excel sheets
>>
>>
>>My first suggestion would be to export them from Excel in a well
>>understood format like CSV (comma-seperated value).
>>
>>Ken
>>
>>On Fri, 2004-06-18 at 14:00, Guenther Schmidt wrote:
>>
>>>Hi,
>>>
>>>I need to develop an application that needs to access MS Excel
>>
>>spreadsheets.
>>
>>>I am very new to Smalltalk - Squeak and Morphic but I
>>
>>nevertheless think
>>
>>>that I'll manage to write that app in Squeak, the biggest
>>
>>obstacle right
>>
>>>know is accessing those spreadsheets, no clue sofar.
>>>
>>>Any tip would be truly appreciated,
>>>
>>>thank upfront
>>>
>>>Günther
> 
> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20040618/77bd61ea/attachment.htm