Web App in Python Using Flask which reads data from Excel file and put output in other Excel file…

Problem Statement :

We have to read an Excel File”Employee_sal.xlsx” containing Employee name and their Salaries. We have to design a Web App in Python which will increment the Salaries of these Employees and Store it in “Out_file.xlsx”…

Kaustubh Chaudhari on LinkedIn: #arthbylw #arth2020 #righteducation

First We will create an Excel file “Employee_sal”:

Now, Create Flask Code:

Create Folder “Excel_app” within it create file “app.py” inside that file write this code :

Now make a folder “templates” inside “Excel_app” and within it create file “index.html” and write this form there :

Now run The App with “python app.py” in Terminal and click on URL of app as shown below:

Now You will be landed to the Webpage, type the increment you desire :

Click on Submit and You will get the Output file on your Desktop as “Out_file.xlsx”:

In this Way we have created an Web App …..

Thank You!!

See you with new Content