Accessing Excel sheets
Welch, Ronald P
ronald.p.welch at BAESYSTEMS.COM
Fri Jun 18 22:00:55 UTC 2004
One other idea might be to use the ODBC package to get at
mailto:Ronald.P.Welch at baesystems.com Phone:(607)770-3701
BAE SYSTEMS Controls 600 Main St Johnson City, NY 13790-1888
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
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
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
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).
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
> and you can't do any formatting.
> -- kurt
>>From: squeak-dev-bounces at lists.squeakfoundation.org
>>[mailto:squeak-dev-bounces at lists.squeakfoundation.org]On Behalf Of Ken
>>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).
>>On Fri, 2004-06-18 at 14:00, Guenther Schmidt wrote:
>>>I need to develop an application that needs to access MS Excel
>>>I am very new to Smalltalk - Squeak and Morphic but I
>>>that I'll manage to write that app in Squeak, the biggest
>>>know is accessing those spreadsheets, no clue sofar.
>>>Any tip would be truly appreciated,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Squeak-dev