Highly recommended for browser automation
Use Cases and Deployment Scope
Using Selenium tied to Microsoft Excel, I can use a SQL query to generate a list of the current projects, then I can automatically download all the required reports. This saves a ton of time and prevents errors.
Pros
- Headless Web Browser
- Browser Automation
- Integration with Python and Microsoft Excel
Cons
- Learning curve if you are new to HTML, VBA or scripting in general
- No GUI, all code based (pro and con)
- Constant need to update chromedriver file
Return on Investment
- Significant time savings, several hours each week minimum
- Less errors, accidents, miss-clicks
- Consistent, correct, efficient data



