On Sat, 8 Jan 2022 23:04:20 -0800 (PST), NArshad wrote: > On Friday, 7 January 2022 at 02:59:17 UTC+5, alister wrote: >> 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 > > > > As written no time to switch from excel to anywhere else but if a > certain database is required to make changes in Excel’s cell values then > which database to use (example Access or what) and after the right > selection of the database, how to import data to a database and then > export back to a compatible format that is to Excel cells…. > > I mean how to do this written below: > > “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” > > The reason I have written: > > “What to write on GitHub or on google search to find the necessary code > to start with? “ > > I will also be requiring a code to start with just as most people do. > The same is the case with tutorials. > > This is not homework and I have been checking openpyxl for the last one > or two months to find what is required by me when I found nothing of > what is required by me then posted on this google group.
1st save the data from excel as a csv file you will find the csv module makes these much easier to deal with, even if you do not import into a db (although even then I would import into sql- lite just for the benefits of the search algorithms) -- Sometime in 1993 NANCY SINATRA will lead a BLOODLESS COUP on GUAM!! -- https://mail.python.org/mailman/listinfo/python-list
