Accessing specific Excel spread sheets

[Win]

This node falls below the community's threshold of quality. You may see it by logging in.

[stefbv]

Try Spreadsheet::ParseExcel.

Greetings, Stefan

[Ratazong]

You are lucky: there are many nodes on this topic on perlmonks! You could try the search-option on the top of this page. Or follow this link.

HTH, Rata

[marto]

Some previous posts by you on this topic:

• Using Excel
• Win32::OLE question solution?
• Win32::OLE - is it the best option?
• Comparing two Excel spread sheets

[tilly]

Since you don't seem to have any actual interest in learning Perl, may I offer you a rate of $200/hour for me to solve your scripting needs?

[davies]

Win32::OLE

Microsoft's advice on how to use it

[Ratazong]

I found the following examples on Win32::OLE even more useful than the Microsoft-advice:

• Using Win32::OLE and Excel - Tips and Tricks (by cacharbe)
• Perl Win::OLE Excel Cheats
Rata

[mr_mischief]

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.