On Thu, 6 Jan 2022 10:55:30 -0800 (PST), 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. > Excel is the wrong application for storing this data - it should be in a database
> 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”. Again Excel is not the correct application for processing this data > > 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. > Database! > 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. > Database > > - 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. Sorry did not spot that this was a homework assignment data should still be imported into a DB (a trivial task) It can be exported back to a compatible format just as easily if hard copy output is required -- "Rembrandt's first name was Beauregard, which is why he never used it." -- Dave Barry -- https://mail.python.org/mailman/listinfo/python-list
