Problems for read excel 2010

Topics: Developer Forum, Project Management Forum, User Forum
Oct 23, 2012 at 11:55 AM

I'm having the problem to read a file in Excel 2010. I was searching and found no solution if they can help me grateful. The problem is this, I took one of your examples to read all the cells of excel, but nothing shows me 2010 format, but the format works since 2003-2007. He wanted to help me if possible.
I leave the code below:

?><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PHPExcel Reader Example #01</title>
<h1>PHPExcel Reader Example #01</h1><h2>Simple File Reader using PHPExcel_IOFactory::load()</h2><?php
/** Include path **/set_include_path(get_include_path() . PATH_SEPARATOR . '../../../Classes/');
/** PHPExcel_IOFactory */include 'PHPExcel/IOFactory.php';

$inputFileName = './sampleData/ministerio2.xls';echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory to identify the format<br />';$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

echo '<hr />';
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);var_dump($sheetData);


Oct 23, 2012 at 9:00 PM
Edited Oct 23, 2012 at 9:01 PM

Does anything display at all? Any error messages? Anything written to PHP or Apache error logs?


Oct 24, 2012 at 11:33 AM

No nothing

Oct 24, 2012 at 12:48 PM

So somewhere in Apache, PHP or PHPExcel there's a bug where nothing whatesoever is displayed.

Do the /Tests examples work for you?

Oct 24, 2012 at 1:16 PM
Edited Oct 24, 2012 at 1:40 PM

Yes work, I've followed me for them to try to get this to work and all work when I put excel 2007 files, but when I put excel 2010 files nothing works


edit: Forget xD Extension for excel 2010 is xlsx, and no xls as excel 2007 xD