Question about django-excel HOT 5 CLOSED

surely, you can as long as your db model won't have: not null and you do not omit primary key if it is not auto-generated.

from django-excel.

First of all, thank you for your reply.

Current excel file contents are as follows:

Do I have to save and use all test1,test2,test3 of Excel to use the above test2 data?
Is there any way to store only test2 in the database?

Because there are so many columns of excel data that I will use, I think it will take a long time to store them all in the database.

Thanks!

from django-excel.

alright, then you will have to use request.FILES['file'].get_sheet() first, then filter out the unwanted data before saving, here are the tutorial for pyexcel, which is the core library for opening the excel sheets: https://pyexcel.readthedocs.io/en/latest

from django-excel.

Thanks!

from django-excel.

Thanks for your help.

The current model is set to Sheet1, and the Excel sheet name is set to Sheet1.

However, if the name of the Excel sheet is sheet1, it works, but if it contains uppercase letters like Sheet1, an error occurs.

How do I read an Excel file named Sheet1?

from django-excel.