What to write or search on github to get the code for what is written below:

MRAB python at mrabarnett.plus.com
Fri Jan 7 15:22:54 EST 2022


On 2022-01-06 18:55, NArshad wrote:
> All this is going to be in python’s flask and HTML only
> 
> 1. First, I have to check in the Excel sheet or table whether the book user has entered is present in the book bank or not.
> 
> 2. If a book is present and the quantity of the required book is greater than 0 (COPIES_LEFT column in excel file) and if the user wants the book, it will be assigned to the user which he will take from the book bank physically. When COPIES_LEFT will is less than or equal to 0 the message will be “Book finished or not present”.
> 
> 3. The quantity of the book in the Excel file will be reduced by 1 in the COPIES_LEFT column and the name of the borrower or user will be entered/added in the Excel file table or sheet already made and the column name is BORROWER’S NAME.
> 
> 4. The borrower’s or user name can be more than one so they will be separated with a comma in the Excel file BORROWER’S NAME column.
> 
> 
> - All functions mentioned above are to be deployed on the website pythonhow.com so make according to https://pythonhow.com/python-tutorial/flask/web-development-with-python-and-flask/
> 
> - Do you know any other websites to deploy a python web application??
> 
> - No time to switch from Excel to anywhere else. Please do not make any changes to the Excel file.
> 
> - Tutorials and repositories of the web for such problems are also required. The same is required for python (flask, Django...) also.
> 
As someone else has already pointed, Excel is the wrong way to do it, 
yet it remains a popular method.

Given that, you can read Excel spreadsheets with 'openpyxl', which is on 
PyPI.


More information about the Python-list mailing list