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
