Title: Error Importing from Excel Last modified: August 21, 2016 --- # Error Importing from Excel * Resolved [arievanwyk](https://wordpress.org/support/users/arievanwyk/) * (@arievanwyk) * [12 years, 8 months ago](https://wordpress.org/support/topic/error-importing-from-excel/) * Hi * This is a Brilliant Plugin and I do understand it’s still in Development, but maybe you can help. * When I’m trying to import my products i receiving a Error * Warning: call_user_func() expects parameter 1 to be a valid callback, class ‘ PHPExcel_CachedObjectStorage_Memory’ not found in /home/cbndco/public_html/wp- content/plugins/ultimate-product-catalogue/PHPExcel/Classes/PHPExcel/CachedObjectStorageFactory. php on line 195 * Fatal error: Class ‘PHPExcel_Worksheet_PageSetup’ not found in /home/cbndco/public_html/ wp-content/plugins/ultimate-product-catalogue/PHPExcel/Classes/PHPExcel/Worksheet. php on line 344 * Thanks * [http://wordpress.org/plugins/ultimate-product-catalogue/](http://wordpress.org/plugins/ultimate-product-catalogue/) Viewing 7 replies - 1 through 7 (of 7 total) * [lchendryx](https://wordpress.org/support/users/lchendryx/) * (@lchendryx) * [12 years, 8 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153508) * I am also getting an error when trying to upload an excel sheet. However, the page goes blank instead of giving me an error message. * [tronics](https://wordpress.org/support/users/tronics/) * (@tronics) * [12 years, 8 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153522) * Please, it would be fine if you could also provide an example excel that shows the features of the import. * How should an average user be able to understand what he is supposed to do with that function. * Otherwise great project. * Regards * [Andre_Kr](https://wordpress.org/support/users/andre_kr/) * (@andre_kr) * [12 years, 8 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153543) * I have the blank page too. Did some debugging. The PHPExcel Class is missing. Download it at [http://phpexcel.codeplex.com/](http://phpexcel.codeplex.com/) Rename the unzipped folder to “PHPExcel” and put it in wp-content/plugins/ultimate- product-catalogue/ The include path that should match now is wp-content/plugins/ ultimate-product-catalogue/PHPExcel/Classes/PHPExcel.php * I still had no luck getting it running. After loading the file the page still goes blank. My php lacks the php_gd2 extension but I dont know why I need an image extension for reading a text xls. * The following requirements should be met prior to using PHPExcel: * PHP version 5.2.0 or higher * PHP extension php_zip enabled *) * PHP extension php_xml enabled* PHP extension php_gd2 enabled (if not compiled in) * The format of the excel file is defined as: $Allowed_Fields = array (“Name” => “Item_Name”, “Description” => “Item_Description”, “Price” => “Item_Price”,“ Image” => “Item_Photo_URL”, “Category” => “Category_Name”, “Sub-Category” => “ SubCategory_Name”); * You need the array keys in your table. Name, Description, Price, Image….. * Also you should know that the import script cant import new categories or sub- categories. They should be added before importing. * Plugin Author [Rustaurius](https://wordpress.org/support/users/rustaurius/) * (@rustaurius) * [12 years, 8 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153547) * Hi All, * First, Andre thanks for the awesome reply! * Like Andre said, the PHPExcel files appear to be missing sometimes when the plugin gets installed. Some users seem to end up with most of the files, others hardly any. I think the problem might be that there are a almost a thousand files in the class, so I’ll try to strip out everything that’s not used by the plugin. I’ll have the stripped down version released with the next version sometime next week. * As for the request for a sample sheet, I’ve added a link to one at the bottom of this page: [http://www.etoilewebdesign.com/web-services/](http://www.etoilewebdesign.com/web-services/) * Thanks for the compliments and understanding it’s still in development! * [Andre_Kr](https://wordpress.org/support/users/andre_kr/) * (@andre_kr) * [12 years, 7 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153587) * You are welcome. And do you have any clue why it still isn’t working after installing PHPExcel? At `$objWorkBook = $objReader->load($Excel_URL);` the php script is killed. I didn’t get any errors but I dont know if wordpress is configured to throwing any errors. I’m not very familiar with wordpress so far. I tried some other methods of the class to load the file, same result. * And it would be a nice improvement if non existing categories and sub categories will be added to the db while importing. * Plugin Author [Rustaurius](https://wordpress.org/support/users/rustaurius/) * (@rustaurius) * [12 years, 7 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153608) * Hi Andre, * You can set `define('WP_DEBUG', true);` * to have WordPress show all errors, which might help us get to the bottom of the problem. * Having categories added automatically wouldn’t be a problem, but sub categories each belong to a parent category so I’m not sure I could see that working. * Plugin Author [Rustaurius](https://wordpress.org/support/users/rustaurius/) * (@rustaurius) * [12 years, 7 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153628) * The newest version has a much smaller number of PHPExcel files (~20% of the total). Uploading from a spreadsheet worked for me when I installed from the WordPress repository, so hopefully this fixed the issue for all of you as well! Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Error Importing from Excel’ is closed to new replies. * ![](https://ps.w.org/ultimate-product-catalogue/assets/icon-128x128.png?rev=1805317) * [Ultimate Product Catalog](https://wordpress.org/plugins/ultimate-product-catalogue/) * [Frequently Asked Questions](https://wordpress.org/plugins/ultimate-product-catalogue/#faq) * [Support Threads](https://wordpress.org/support/plugin/ultimate-product-catalogue/) * [Active Topics](https://wordpress.org/support/plugin/ultimate-product-catalogue/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/ultimate-product-catalogue/unresolved/) * [Reviews](https://wordpress.org/support/plugin/ultimate-product-catalogue/reviews/) * 7 replies * 5 participants * Last reply from: [Rustaurius](https://wordpress.org/support/users/rustaurius/) * Last activity: [12 years, 7 months ago](https://wordpress.org/support/topic/error-importing-from-excel/#post-4153628) * Status: resolved