Accessing specific Excel spread sheets

Win has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Accessing specific Excel spread sheets by stefbv (Priest) on Jan 25, 2011 at 15:17 UTC
Try Spreadsheet::ParseExcel. Greetings, Stefan	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re: Accessing specific Excel spread sheets by Ratazong (Monsignor) on Jan 25, 2011 at 15:21 UTC
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	[reply]
Re: Accessing specific Excel spread sheets by marto (Cardinal) on Jan 25, 2011 at 15:35 UTC
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	[reply]
Re: Accessing specific Excel spread sheets by tilly (Archbishop) on Jan 26, 2011 at 07:24 UTC
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?	[reply]
Re: Accessing specific Excel spread sheets by davies (Monsignor) on Jan 25, 2011 at 15:22 UTC
Win32::OLE Microsoft's advice on how to use it	[reply]
Re^2: Accessing specific Excel spread sheets by Ratazong (Monsignor) on Jan 25, 2011 at 15:56 UTC
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	[reply]
Re: Accessing specific Excel spread sheets by mr_mischief (Monsignor) on Jan 30, 2011 at 20:10 UTC
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.	[reply] [d/l] [select]