Sign In
Create your first automation in just a few minutes.Try Studio Web →
Validate Workbook Template
by Kunal Hore
2
Snippet
<100
Summary
Summary
Validate runtime input-file template with the agreed business input-file template. Verifies sheet names, header names and locations.
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
Dependencies ( Windows - Legacy ) > UiPath.Excel.Activities = 2.11.4 > UiPath.System.Activities = 21.10.3 > UiPath.UIAutomation.Activities = 21.10.4
Code Language
Visual Basic
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0Updated
December 14, 2021Works with
Studio: 21.10.4 - 22.10
Certification
Silver Certified
Application
Support
UiPath Community Support
Resources
Similar Listings
