[FIXED] How to display the names of the sheets of xls file using PHPexcel?

Issue

How to display the names of the sheets of xls file using PHPexcel?

$objWorksheet = $objPHPExcel->setActiveSheetIndex(0); ???

Solution

$objPHPExcel->getSheetNames();

will return a list of all worksheet names

$objWorksheet->getTitle();

will return the name of the worksheet in $objWorksheet

EDIT

How to access a sheet by name/title:

$objWorksheet = $objPHPExcel->getSheetByName('Worksheet1'); 

Answered By - Mark Baker

Answer Checked By - Willingham (PHPFixing Volunteer)