Right, new that it used OLE::Storage_Lite, but for some reason I always
thought that OLE_Storage and OLE_Storage_Lite was based on Win32::OLE, I
guess I was wrong. Maybe another driver or a ported one is needed for
non-win platforms.
Ilya Sterin
-----Original Message-----
From: Steve Sapovits
To: Sterin, Ilya; 'Steve Sapovits '; 'Thomas A. Lowery ';
''[EMAIL PROTECTED]' '
Sent: 05/01/2001 10:36 AM
Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
Actually, Spreadsheet::ParseExcel uses OLE::Storage. From
tests I ran before, that works out of the box on UNIX platforms,
whereas OLE appears to be a Windows only thing and ODBC will
only work on Solaris with an ODBC driver I have not been able
to find for free.
If I'm wrong about this and someone's used either DBD::ADO or
DBD::ODBC on Sun/Solaris, I'd like to hear how you did it.
----
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
> -----Original Message-----
> From: Sterin, Ilya [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 12:06 PM
> To: 'Steve Sapovits '; 'Thomas A. Lowery '; ''[EMAIL PROTECTED]' '
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be
done?
>
> Spreadsheet::ParseExcel also uses Win32::OLE to interact with the
> spreadsheet, so I am not sure why both would not work on non win32
> platforms.
>
> Ilya Sterin
>
> -----Original Message-----
> From: Steve Sapovits
> To: Thomas A. Lowery; '[EMAIL PROTECTED]'
> Sent: 05/01/2001 9:55 AM
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> I'm curious if these will work on a UNIX (Solaris) platform.
> I tried a while ago and was only able to run them on Windows.
>
> We deal with a fair number of spreadsheets here, all dumped
> on UNIX shares and then meant to interact with our Oracle
> database on that platform. I typically do one of two things:
> 1) Have people save the data as delimited text or CSV and use
> Perl tools to parse those; or 2) Use Spreadsheet::ParseExcel
> to extract data directly from the spreadsheet, then process
> the data as it's extracted.
>
> Also note that for creating Excel spreadsheets on any platform,
> there's Spreadsheet::WriteExcel, which I've personally found to
> be a pretty good piece of code.
>
> ----
> Steve Sapovits
> Global Sports Interactive
> Work Email: [EMAIL PROTECTED]
> Home Email: [EMAIL PROTECTED]
> Work Phone: 610-491-7087
> Cell: 610-574-7706
> Pager: 877-239-4003
>
> > -----Original Message-----
> > From: Thomas A. Lowery [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 01, 2001 8:14 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: Re: Extract data from MS Excel Spreadsheets. Can it be
> done?
> >
> > Yes, DBD::ADO or DBD::ODBC. Both will talk to Excel and Access.
> >
> > Tom
> >
> > On Tue, May 01, 2001 at 12:38:45PM +0100, Kutler, Christopher wrote:
> > > Hi,
> > >
> > > Does anyone know whether it is possible to connect to an Excel
> > spreadsheet
> > > and extract data in a way similar one would do with an Access
> database?
> > If
> > > so, how?
> > >
> > > thanks in anticipation
> >
> > --
> > Thomas A. Lowery
> > See DBI/FAQ http://tlowery.hypermart.net
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
