How to intergrate openpyxl with django and using the excel sheet as the database to query data

2021-01-25 Thread Ernest Thuku
Hello Everyone, I have a python file which I run on the terminal and give me the result that I want. I want to to do the same via a web app whereby instead of interacting with the terminal, I can do that via a browser through a form. I have decided to choose django as the server. Below is the file

Re: How to intergrate openpyxl with django and using the excel sheet as the database to query data

2021-01-25 Thread Kasper Laudrup
Hi Ernest, On 25/01/2021 10.25, Ernest Thuku wrote: Hello Everyone, I have a python file which I run on the terminal and give me the result that I want. I want to to do the same via a web app whereby instead of interacting with the terminal, I can do that via a browser through a form. I have

Re: How to intergrate openpyxl with django and using the excel sheet as the database to query data

2021-01-25 Thread Ernest Thuku
Hello kasper, thank you so much for the information. I know how to use the django forms. The issue was where will I include the python file above. If I decide to uploadthe excel file and put store it in the django admin, how will I access its content. I hope its clear now maybe you can help. On Mo

Re: How to intergrate openpyxl with django and using the excel sheet as the database to query data

2021-01-25 Thread Ernest Thuku
this is the view to the model form that i have created. def findFault(request): form = findForm(request.POST or None) if form.is_valid(): instance = form.save(commit=False) instance.user = request.user instance.save() return redirect("home") context = { 'form': form, } return render(request, 'find

Re: How to intergrate openpyxl with django and using the excel sheet as the database to query data

2021-01-25 Thread Kasper Laudrup
Hi Ernest, On 25/01/2021 10.43, Ernest Thuku wrote: Hello kasper, thank you so much for the information. I know how to use the django forms. The issue was where will I include the python file above. I'm not sure I understand the problem. The file you posted earlier just contains a Python fun

Re: How to set daily update limit for django model(db)?

2021-01-25 Thread Jaimik Patel
Hi Shailesh, you can define the function with the use of DateTime module, which changes the value of the variable daily for the count. https://stackoverflow.com/questions/52305294/changing-a-variable-based-on-current-time-of-day and for excel, you can get the number of lines in the file, and you