This project is based on Python-Selenium to automate live website (moneycontrol.com/fixed-deposit-calculator). In this project , the website is automated using selenium webdriver and testcases are executed and based on the result(pass or fail) the excel is updated automatically.
This is built with keeping in mind that a tester needs put 20% of effort to get the 80% of output by automating the complete testing process
Tech Satck: Selenium, Webdriver , Python , openpyxl , Excel utils
- Selenium WebDriver: Utilized it for automating web browser interactions and validations.
- OpenPyXL: Used it to read from excel file and write into Excel files to manage test data and results.
final.final.mp4
- Developed Python scripts (main.py and fixeddepo.py) to automate the testing process.
- Utilized Selenium WebDriver to interact with the fixed deposit calculator web application.
- Integrated OpenPyXL for reading test data from Excel files and writing test results back to the same files.
- Implemented functions to handle Excel file operations, such as getting row and column counts, reading data, writing data, and applying cell formatting.
- Created test scenarios to validate the accuracy of the fixed deposit calculator by comparing expected maturity values with actual values obtained from the web application.
| Excel sheet before automation |
|---|
 |
| Automation(Execution) |
|---|
 |
| Excel sheet after automation (Updated Automatically) |
|---|
 |