I will not write code for you for free. I also will point out that you will get more help by asking what you're doing wrong using a module than asking others to teach you about its features beforehand. You should search a little before asking.
What I will do, however, is since you asked a question I can quickly and easily answer for someone else who might find this thread in the future, is answer it quickly and simply for their benefit.
Using the Spreadsheet::ParseExcel module, you want the worksheet method to get the contents of a sheet by name or the worksheets method to get a list of worksheets through which you can iterate.
With DBI::Excel (which is listed as in alpha development) a worksheet is treated as a database table which you can refer to by name as if it was any other database table. You can get a list of tables (worksheets) from that with the list_tables private driver function.
I'm not sure how to extract data from specific worksheets using other spreadsheet modules, as I've yet to have that need myself.
|