Creating Hash from Excel 2007

perl@1983 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I have a Excel spreadsheet where in I have defined few variables and their values (a kind of configuration). I would like to read each variable name and initialize its value. I am new to Perl and was wondering what can be best approach to do that? Can it be taken into a hash at one go? Otherwise, I'll have to put if-else or switch statements as many times as there are variables, which I think would not be feasible in longer run. The format of Excel is: Cell A1 contains variable name Cell A2 contains its value Cell B1 contains another variable name Cell B2 contains its value and so on... Thanks in advance.

Comment on Creating Hash from Excel 2007

Replies are listed 'Best First'.
Re: Creating Hash from Excel 2007 by chilledham (Friar) on May 17, 2011 at 18:41 UTC
Just to clarify Spreadsheet::ParseExcel won't work with Excel 2007 files (unless you save them in the older .xls format, but then they're not Excel 2007 formatted). Take eff_i_g's advice and look at Spreadsheet::Read. There is also Spreadsheet::XLSX. Good luck!	[reply]
Re^2: Creating Hash from Excel 2007 by perl@1983 (Sexton) on May 18, 2011 at 14:53 UTC
Thank you everyone!! I am using Office 2007 Spreadsheet::XLSX module.	[reply]
Re: Creating Hash from Excel 2007 by wind (Priest) on May 17, 2011 at 17:11 UTC
Just use Spreadsheet::ParseExcel. Iterate on the cells assigning each row to a key/value pair in your configuration hash.	[reply]
Re: Creating Hash from Excel 2007 by eff_i_g (Curate) on May 17, 2011 at 17:15 UTC
There's also Spreadsheet::Read.	[reply]