PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Excel2007 Reader Error #1350

Open LukasGI opened 6 years ago

LukasGI commented 6 years ago

Hello, I have some XLSX files, that can be normally opened and viewed in Excel 2010, however, I am not able to load them using PHPExcel. I have uploaded one of them here: 2017-11-18.xlsx

Can you please help me with this?

LukasGI commented 6 years ago

I have finally managed to solve this problem, although it is rather "hack" than a proper solution.

First of all, a had to comment out these lince in method PHPExcel_Shared_File::realpath: /*if (file_exists($pFilename)) { $returnValue = realpath($pFilename); }*/

Next, I had to adjust the result of the method PHPExcel_Reader_Excel2007::_getFromZipArchive: $contents = str_replace('x:', '', $contents);

Now, if someone could please look into this and propose a real solution to this problem.