reading data from an excel sheet in perl

Question

I have a hash of result messages. Each message has 4-5 different parameters. I want to match parameter values with the values stored in an excel sheet. If they match its pass or fail Can you help me how to read from an excel sheet and match it line by line with my current message in hash.

score 2 · Answer 1 · answered Aug 09 '13 at 15:13

2

The best way to read from an Excel file is using a CPAN module, like Spreadsheet::XLSX

answered Aug 09 '13 at 15:13

Miguel Prz

13,718
29
42

Can you help me with cpan modules..I have no idea how to use them in my script.Basic steps would be appreciated – user2486369 Aug 09 '13 at 15:59
http://www.cpan.org/modules/INSTALL.html, cpan is a great repository of very helpful modules – Miguel Prz Aug 09 '13 at 16:48

score 0 · Answer 2 · answered Aug 09 '13 at 16:53

If you are using MS Excel 2003 or earlier, you can use - ParseExcel

If you are using excel 2007 or higher (xlsx), then Spreadsheet::XLSX does the job.

If you want something very quick and simple try - Simple Its an easy to use wrapper around ParseExcel.

reading data from an excel sheet in perl

2 Answers2