MarketplaceListingsSnippetValidate Workbook Template

Validate Workbook Template

Bronze Certified

Snippet

2 reviews

3

Validate Workbook Template

Bronze Certified

Snippet

2 reviews

3


Summary

Validate runtime input-file template with the agreed business input-file template. Verifies sheet names, header names and locations.

carouselImage0

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.


Benefits

ᵒ 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.

Published: 21 Dec 2021 | Updated: 21 Dec 2021

Kunal Hore
Software Developer

License

MIT


Code Language

Visual Basic


Runtime

Windows (.Net 5.0 or higher)


Tags

Template Validation
Check Header Name
Check Sheet Exist
Check Header Address

Compatibility

Studio: 2021.10.4+


Dependencies

Dependencies ( Windows - Legacy ) > UiPath.Excel.Activities = 2.11.4 > UiPath.System.Activities = 21.10.3 > UiPath.UIAutomation.Activities = 21.10.4



Similar Listings