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

2021-01-26 Thread Ernest Thuku
Well thank you so much for this...I really appreciate..let me try it and I will let you know On Wed, 27 Jan 2021 03:12 Gabriel Araya Garcia, wrote: > In top of views files (views.py) you must put: > import openpyxl > from openpyxl import Workbook > from openpyxl.styles import

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

2021-01-26 Thread Gabriel Araya Garcia
In top of views files (views.py) you must put: import openpyxl from openpyxl import Workbook from openpyxl.styles import Alignment,Border,Font,PatternFill,Side from openpyxl.styles import colors from openpyxl.styles import Font, Color,Fill from openpyxl.styles.borders import BORDER_THIN from

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

2021-01-26 Thread Kasper Laudrup
On 26/01/2021 21.37, Ernest Thuku wrote: Yeah that is what I am talking about. I need  to integrate this screenshot below in django now. The link name, distance etc to be in  a form. I'm not really sure I understand what you mean. You say you want to import some existing data to a database

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

2021-01-26 Thread Ernest Thuku
Yeah that is what I am talking about. I need to integrate this screenshot below in django now. The link name, distance etc to be in a form. On Tue, Jan 26, 2021 at 9:58 PM Kasper Laudrup wrote: > On 26/01/2021 15.19, Ernest Thuku wrote: > > Hey Kasper, yes I ned to save it as a model so that

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

2021-01-26 Thread Kasper Laudrup
On 26/01/2021 15.19, Ernest Thuku wrote: Hey Kasper, yes I ned to save it as a model so that i can use it to access information. OK, so what you really want to do is to create a model with the same fields as the ones in your spreadsheet and then import your data into that model? /Kasper

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

2021-01-26 Thread Ernest Thuku
Hey Kasper, yes I ned to save it as a model so that i can use it to access information. On Mon, Jan 25, 2021 at 3:03 PM Kasper Laudrup wrote: > 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

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

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,

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

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

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