How to read multiple worksheet from a single excel file in php?

Question

I have an excel sheet having three worksheets, I am having trouble in fetching records from second worksheet.

All three worksheet is having different kind of records and with different fields, I try to google it but couldn't find a solution.

Answer 1

You can refer,

http://phpexcel.codeplex.com/

This is good project developed for excel reader and writer. You can use it for your project. It has all necessary methods that are required for excel.