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

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

Hello,

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

Thx,

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

Replace

$worksheetNames = $objReader->listWorksheets();

with

$worksheetNames = $objReader->listWorksheetNames();

- Christopher Mullins