Validate Workbook Template
by Kunal Hore
2
13
Validate Workbook Template
by Kunal Hore
2
Snippet
13
Summary
Summary
Overview
Overview
There are business requirements / scenarios where the input file submitted for processing must be template validated in order to avoid having the data loaded from incorrect files.
This snippet helps validate runtime input-file templates with the agreed business input-file template. Also, it verifies the sheet names, header names and their locations.
Features
Features
ᵒ Provides complete error logs as string, which can be used in the body of the emails to notify business users.
ᵒ Quick validation and rectification.
ᵒ Template Descriptor File can be easily updated and maintained to handle changes within business file template without any changes to the code.
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0Updated
14 Dec 2021Certification
Silver Certified
Tags
Template Validation
Check Header Name
Check Sheet Exist
Check Header Address
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
English
English
日本語