PHPExcel is a PHP library for reading, creating and editing spreadsheet files, including XLS, XLSX, CSV and ODS.
These instructions apply to older extension versions that use PHPExcel. PHPExcel is no longer maintained. See the official PHPExcel repository.
Some older versions of our extensions use PHPExcel for import and export: Related Options (on opencart.com), Related Options PRO (on opencart.com), Product Option Image PRO (on opencart.com), Product Option Image Ultimate (on opencart.com) and Parent-child Options (on opencart.com).
PHPExcel is needed only for these import and export features. You do not need to install it if you do not use them.
PHP compatibility
The original, unmodified PHPExcel library is not compatible with PHP 8.0 or later. Compatibility with PHP 7 depends on the PHPExcel version and any fixes applied; PHP 7.4 also reports deprecated syntax used by the library. Do not assume that an old PHPExcel package supports every PHP 7 version.
Newer extension versions
Newer versions of our OpenCart 3 extensions use OpenSpout or Box/Spout for XLSX import and export, depending on the extension version and the server's PHP version. If the required library is missing, use the automatic installation button in the extension settings. You do not need to upload the library files manually.
Read more about OpenSpout and its automatic installation in our extensions.
How to install PHPExcel for older OpenCart 2.x extensions
For older OpenCart 2.x extensions that require PHPExcel, the library files are not included in the extension package. Install them separately:
- Download the final PHPExcel release from the official releases page.
- Create a
PHPExceldirectory inside the OpenCartsystemdirectory:/system/PHPExcel/. - Copy the
Classesdirectory and all its contents from the downloaded package into/system/PHPExcel/. The resulting path should be/system/PHPExcel/Classes/.