Reading a XLSX-File fails about phpexcel HOT 5 CLOSED

Is there any particular reason why you can't open files from Suunto movescount.com directly? Any errors thrown? Any missing data? Are they actually OfficeOpenXML files? What does identify() return? Any clues whatsoever?

from phpexcel.

Hello!

I have the same problem. Can't open movescount .xlsx file directly with PHPExcel...
Problem is getSheetCount delivers 0 and of course no worksheets are available.

Funny thing aside: Apple Numbers can't open it either. "No valid Excel file!"

I don't really understand which "Excel" format Suunto is using.

Richard

from phpexcel.

It looks like OfficeOpenXML (when I open it with Texteditor) and identify delivers "Excel2007".

from phpexcel.

This is because downloaded file is in HTML format (but names as .xmlx)

from phpexcel.

I did the following steps to fix this.

$inputFileName = 'test.xlsx';
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($inputFileName);

Install the ZipArchive if not already installed
sudo apt-get install php7.0-zip
sudo service apache2 restart

from phpexcel.