<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: Accessing Excel sheets</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>One other idea might be to use the ODBC package to get at</FONT>
<BR><FONT SIZE=2>the data.</FONT>
</P>
<P><FONT SIZE=2>----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=----------</FONT>
<BR><FONT SIZE=2><A HREF="mailto:Ronald.P.Welch@baesystems.com">mailto:Ronald.P.Welch@baesystems.com</A> Phone:(607)770-3701</FONT>
<BR><FONT SIZE=2>BAE SYSTEMS Controls 600 Main St Johnson City, NY 13790-1888</FONT>
<BR><FONT SIZE=2>----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Guenther Schmidt [<A HREF="mailto:gue.schmidt@web.de">mailto:gue.schmidt@web.de</A>] </FONT>
<BR><FONT SIZE=2>Sent: Friday, June 18, 2004 5:43 PM</FONT>
<BR><FONT SIZE=2>To: squeak-dev@lists.squeakfoundation.org</FONT>
<BR><FONT SIZE=2>Subject: Re: Accessing Excel sheets</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi,</FONT>
</P>
<P><FONT SIZE=2>Thank you all.</FONT>
</P>
<P><FONT SIZE=2>I had hoped there would be a way to access at least the data from the </FONT>
<BR><FONT SIZE=2>excel sheets directly via squeak without the need to convert the files </FONT>
<BR><FONT SIZE=2>first.</FONT>
</P>
<P><FONT SIZE=2>At this time I rather doubt I'd be able to write my own parser for excel </FONT>
<BR><FONT SIZE=2>sheets in squeak ;-). I had hoped somebody already had.</FONT>
</P>
<P><FONT SIZE=2>Anyway I reckon converting it into CSVs first is propably the most </FONT>
<BR><FONT SIZE=2>feasable option.</FONT>
</P>
<P><FONT SIZE=2>Squeak is very cool and it is far more consistent than anything I've </FONT>
<BR><FONT SIZE=2>tried sofar. (I had a go at Lisp, Scheme and .NET).</FONT>
</P>
<P><FONT SIZE=2>Günther</FONT>
</P>
<BR>
<P><FONT SIZE=2>Kurt Thams wrote:</FONT>
<BR><FONT SIZE=2>> FYI: You can generate a CSV text file, and if you give the filename</FONT>
<BR><FONT SIZE=2>> extension ".xls", Excel will happily open it upon double-clicking.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Of course, if you use CSV you can only put data in the fields, not formulae,</FONT>
<BR><FONT SIZE=2>> and you can't do any formatting.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> -- kurt</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>>>-----Original Message-----</FONT>
<BR><FONT SIZE=2>>>From: squeak-dev-bounces@lists.squeakfoundation.org</FONT>
<BR><FONT SIZE=2>>>[<A HREF="mailto:squeak-dev-bounces@lists.squeakfoundation.org">mailto:squeak-dev-bounces@lists.squeakfoundation.org</A>]On Behalf Of Ken</FONT>
<BR><FONT SIZE=2>>>Causey</FONT>
<BR><FONT SIZE=2>>>Sent: Friday, June 18, 2004 1:49 PM</FONT>
<BR><FONT SIZE=2>>>To: The general-purpose Squeak developers list</FONT>
<BR><FONT SIZE=2>>>Subject: Re: Accessing Excel sheets</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>My first suggestion would be to export them from Excel in a well</FONT>
<BR><FONT SIZE=2>>>understood format like CSV (comma-seperated value).</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>Ken</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>On Fri, 2004-06-18 at 14:00, Guenther Schmidt wrote:</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>>Hi,</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>>I need to develop an application that needs to access MS Excel</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>spreadsheets.</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>>I am very new to Smalltalk - Squeak and Morphic but I</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>nevertheless think</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>>that I'll manage to write that app in Squeak, the biggest</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>obstacle right</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>>know is accessing those spreadsheets, no clue sofar.</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>>Any tip would be truly appreciated,</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>>thank upfront</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>>Günther</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
</P>
</BODY>
</HTML>