Project Overview
Assigned to enhance an existing robotic automation system, the project involved significant modifications to the "FIRST ROBOT" and the development of a new "Second Robot". A key requirement was enabling control of the automation directly from an Excel add-in. Additionally, a gear icon was integrated for real-time adjustments of operational speed and task delay durations. One of the main challenges was extracting data from Excel and submitting it through the ESTA Visa Application website.
Project Highlights
Objective
Refine the existing robot automation system, introduce a new robot, and ensure seamless integration with Excel, all while enabling user-driven customization.
Key Features
- Enhanced FIRST ROBOT: Improved upon the initial robot based on specific instructions, adding nuanced features.
- Second Robot Creation: Developed a new robot with distinct functionalities, ensuring it works cohesively with the first.
- Excel Integration: Automated data extraction from Excel sheets for the purpose of populating the ESTA Visa Application website.
- Real-Time Adjustments: Incorporated a gear icon that facilitates on-the-fly modifications to robot execution speed and task delays.
- Simulated Environment Development: Given the proprietary nature of the client's database, a temporary website was constructed to replicate the platform, ensuring a genuine testbed for robot operations.
Technologies Used
- VB.Net Programming Language: The core programming language for the robot automation.
- Selenium: Utilized for automating and controlling the Edge browser, interfacing with the robots.
- Microsoft Excel: Used for data extraction, serving as the primary data source for the robots.
Leave a Comment