Excel Sheet and Column Validator
This bot will help to validate your input Excel file. It can also validate whether the sheet and column exist.
Top Benefits
- This will validate the sheet exist in a given Excel file
- This will validate the column exist in a given Excel file
Tasks
- open Python, Execute function, Close python
This bot will help validate any given Excel file, which can help to reduce the BTO failour.
This bot has 3 input parameter, these are as below (strLogFIlePath, strSurceFileInput, strValidationType) and one output parameter (strStatus) to store the result.
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Customer Service & SupportFinance & AccountingHuman Resources
- Category
- RPA Developer ToolsUtility
- Downloads
- 275
- Vendor
- Automation Type
- Bot
- Last Updated
- December 17, 2021
- First Published
- December 16, 2021
- Platform
- Automation 360
- ReadMe
- ReadMe
- Support
-
- Community Support Only
- Pathfinder Community Developer Forum
- Bot Store FAQs
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Python to be installed
- LogFile path is required
- strSurceFileInput
- strValidationType