Import/Export Excel formatting issues...Help please! :(

Hey everyone! I am a noobie and have been trying to read up as much as I could about the import/export module but I can't get it working properly.

I have installed it correctly, but when I import my excel file it tells me it's the incorrect format. So what I tried to do was export my backup from opencart and use that as a template. So I tried to switch the data from my old file to the one that opencart gave me on export. When I finally got it switched and I try to upload it, it gives me this: system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91


I dont know what to do. I have attached my original XLS file here, can someone help me format this correctly?? I would greatly appreciate it.

Can anyone help? Please?

This is the error I get when I try adding a product that from the exported opencart XLS sheet


Fatal Error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /home1/vueworig/public_html/hbtest/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /home1/vueworig/public_html/hbtest/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /home1/vueworig/public_html/hbtest/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /home1/vueworig/public_html/hbtest/admin/model/tool/export.php(1582): PHPExcel_Reader_Excel5->load('/var/tmp/php6ng...') #3 /home1/vueworig/public_html/hbtest/admin/controller/tool/export.php(13): ModelToolExport->upload('/var/tmp/php6ng...') #4 [internal function]: ControllerToolExport->index() #5 /home1/vueworig/public_html/hbtest/vqmod/vqcache/vq-system_engine_front.php(48): call_user_func_array(Array, Array) #6 /home1/vueworig/public_html/hbtest/vqmod/vqcache/vq-system_engine_front.php(29): Front->execute(Object(Action)) #7 /home1/vueworig/public_html/hbt in /home1/vueworig/public_html/hbtest/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91

I experienced the exact same error when using an .xls-file from Apple Numbers.

Fixed it by altering the system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php. Just add this line, like shown in the following link https://gist.github.com/762095