Spreadsheet::ParseExcel will help you to do what you want, but it can be difficult to use. A relatively new module that I haven't used, Spreadsheet::BasicRead, provides the main ParseExcel functionality with what may be a more intuitive interface.

Also see Index of Spreadsheet FAQs, which helped me when I had a similar problem.