top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Open Cart Error: Uploaded file is not a valid spreadsheet file or its values are not in the expected formats?

+4 votes
424 views

I'm using Bulk Export/ Import Extension in OpenCart .export is working well but,when import file Error:Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

posted Dec 2, 2015 by Vrije Mani Upadhyay

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

I have tested the bulk export import extension on our own OpenCart installation. I have not experienced any issues with importing, even after changing the data in the file. The error leads me to think the OpenCart has issue with either the format of the file, which should be XLSX, or that the formatting of one or more of the columns is incorrect.

I was able to cause the error, but only after intentionally changing the save format of the file.. Changing it back to xls/xlsx allowed it to be imported properly. Be sure that the saved file you are uploading is indeed XLSX. And if that is the case, you will want to check the columns to ensure that they are either numeric, text, or datetime as the original file exported.

answer Dec 29, 2015 by Rahul Singh
Similar Questions
+3 votes

I have installed Opencart 1.5.6.4 as a fresh install. Post installation everything works like a charm, but the users aren't receiving confirmation emails on account registration, forgot password or on orders. I have tried following work around from Opencart forum, yet to be successful. If I'm using customized php auto response mail application, I'm able to send the same but not working with Opencart.
Though it shows mail sent, but not received

...