Sheet name containing accent (é è ç ....etc)

Topics: Developer Forum, Project Management Forum, User Forum
Dec 3, 2012 at 8:51 AM


How can i get to load only one sheet by name containing an accent ? By the way i tried to use the method bellow 

echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'
;$objReader = PHPExcel_IOFactory::createReader($inputFileType); $objReader = PHPExcel_IOFactory::createReaderForFile($inputFileName); $worksheetNames = $objReader->listWorksheets(); foreach ($worksheetNames as $sheetName) { echo $sheetName, '
; }

But it seems like the listWorksheets() function is undefined. (am using the latest version);

Fatal error: Call to undefined method PHPExcel_Reader_Excel5::listWorksheets() in C:\Program Files\wamp\www\index.php on line 71


Dec 3, 2012 at 6:00 PM
Edited Dec 3, 2012 at 7:03 PM


$worksheetNames = $objReader->listWorksheets();


$worksheetNames = $objReader->listWorksheetNames();

- Christopher Mullins