Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: Perl to convert a named workseet from an xlsx workbook with multiple worksheets into a csv fileby Loops (Curate) |
on Nov 22, 2014 at 02:12 UTC ( [id://1108071]=note: print w/replies, xml ) | Need Help?? |
Looks like Spreadsheet::BasicRead doesn't have the ability to select sheet by name. But it does allow you to select each sheet by number, and then query its name... so:
And then before your csv export code runs, do:
Error checking should be added of course, currently it'll just silently fail if the sheet you choose doesn't actually exist.
In Section
Seekers of Perl Wisdom
|
|