Import/Export PHPExcel error on import

Running at hostgator shared Apache. Installed Import/Export on OpenCart 1.4.9. Export works fine, but import generates this error:

Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mcgreal/public_html/admin/model/tool/export.php on line 1166

I didn't make any changes to the exported file, nor did I open it.

McGreal wrote:Running at hostgator shared Apache. Installed Import/Export on OpenCart 1.4.9. Export works fine, but import generates this error:

Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mcgreal/public_html/admin/model/tool/export.php on line 1166

I didn't make any changes to the exported file, nor did I open it.

i too have a similar problem.

2011-04-18 2:25:57 - PHP Fatal Error: Class 'ZipArchive' not found in /home/rscherer/public_html/bookstore/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53
2011-04-18 2:27:20 - PHP Fatal Error: Class 'PHPExcel_Worksheet_PageSetup' not found in /home/rscherer/public_html/bookstore/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 337

2.2.16
PHP version 5.2.14
MySQL version 5.0.92-community
Architecture x86_64
Operating system linux

Can someone help please?

I have this problem too!

Fatal Error: Class 'ZipArchive' not found in /home/blahblahblah/public_html/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

yiyinlah wrote:Can someone help please?

I have this problem too!

Fatal Error: Class 'ZipArchive' not found in /home/blahblahblah/public_html/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

Im having the same error.. any resolve?

I have same problem. After uploading xls file, this error is occuring


Fatal error: Class 'ZipArchive' not found in /home/blahblah/public_html/opencart.itemple.in/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53
Fatal Error: Class 'ZipArchive' not found in /home/blahblah/public_html/opencart.itemple.in/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

I have the exact same error when importing a .csv file. Exporting works fine. I am using import/export v1-5-1-x on OpenCart v1-5-1-3-1.

When I try importing a .xls file I get:

Fatal error: Class 'PHPExcel_CachedObjectStorage_Memory' not found in /home/....../public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorageFactory.php on line 123
Fatal Error: Class 'PHPExcel_CachedObjectStorage_Memory' not found in /home/......./public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorageFactory.php on line 123

Has there been any resolution to this?

Thanks,
Taylor

Problem solved. Turns out there were a few files missing in my PHPExcel folder. I'm not sure why they were left out, because I uploaded all the folders together then unzipped them on my server..

In any case, I should have double checked. Hope this helps if you're experiencing the same error. Thanks to JNeuhoff for the extension and the support.

-Taylor

Hi,

I encountered a similar error and I've copied the PHPExcel files but still encounter the same error.
Hope someone can help.

Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /DATA/.../admin/model/tool/export.php on line 2573

Hi,

I encountered the same issue:

Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /DATA/myclick/public_html/store/admin/model/tool/export.php on line 2573

The file is located in store/system/PHPExcel/Classes/PHPExcel.php.

I've tried changing the path to store/system/PHPExcel and have double check that all the files are copied correctly but still encountering this.

Can someone please help?

Change the file path from

require_once('Classes/PHPExcel.php' );
TO
require_once(DIR_SYSTEM.'PHPExcel/Classes/PHPExcel.php' );

Change it everywhere in the export.php file (admin/model/tool/export.php)

It solved my problem and might be helpful for you also
Try it.
Thanks