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.