MarketplaceListingsSnippetValidate Workbook Template

Validate Workbook Template

by Kunal Hore

2

10

Validate Workbook Template

by Kunal Hore

2

Snippet

10

carouselImage0

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

Publisher

Kunal Hore

Visit Publisher's Page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0

Updated

14 Dec 2021

Certification

Silver Certified

Tags

Template Validation
Check Header Name
Check Sheet Exist
Check Header Address

Application

Microsoft Excel

Support

UiPath Community Support

Resources