Re: how do i extract data from excel sheet?

In addition to the advice just above, you may also be interested in making use of OLE automation if your script is running under Windows. See Win32::OLE. You don't give us any details as to what you're trying to do (get at an Excel file itself or interact with a running copy of excel), so one of these posts should have the information you need.

As far as "database" stuff goes, you may be confusing Excel with Access. To my knowledge, Excel doesn't "export" its worksheets with any database-ish mechanism at all.

Comment on Re: how do i extract data from excel sheet?

Replies are listed 'Best First'.
Re: Re: how do i extract data from excel sheet? by myocom (Deacon) on Dec 30, 2000 at 04:51 UTC
As far as "database" stuff goes, you may be confusing Excel with Access. To my knowledge, Excel doesn't "export" its worksheets with any database-ish mechanism at all. No, that's true, but you can use ODBC (and therefore Win32::ODBC), for example, to read from an Excel worksheet.	[reply]
Re: Re: how do i extract data from excel sheet? by jmcnamara (Monsignor) on Jan 02, 2001 at 18:21 UTC
As far as "database" stuff goes, you may be confusing Excel with Access. To my knowledge, Excel doesn't "export" its worksheets with any database-ish mechanism at all. Data in Excel is stored in a database-like format although this mechanism is a secondary feature. It is there to allow DB applications to read the data although Excel itself doesn't strictly require it. You can access Excel data for reading and writing using ODBC or ADO. John. --	[reply]