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.
--
https://mail.python.org/mailman/listinfo/python-list
