import is success , But the Data is not stored

[laolu94678]

import is success , and it return "Saved" ,But the Data is not stored , I think something is wrong ,but don't konw where..

127.0.0.1 - - [06/Aug/2017 22:05:35] "�[37mPOST /import HTTP/1.1�[0m" 200 -

[chfw]

Your bug report is appreciated. It is a showstopper and was under the radar for a long time I guess. It is a reputation-saver.

The change else(pyexcel-io) was that the sample-data.xls should have its sheet name match the database name. Sheet 'post' -> Post table, Sheet 'category' -> Category table.

[laolu94678]

Thanks for your reply.
I would like to know how to upload any excel and store it in my database.I can know all the tables I have uploaded so that I can retrieve it according to my needs

[chfw]

I understand your use case that you would like to import any excel sheet without pre-defining any database tables. However, pyexcel family has weak support for databases. I will find a time slot to write a strong import functions that does automatic database import. Please watch this project for further updates.