MarketplaceStudioSnippetValidate Workbook Template

Create your first automation in just a few minutes.Try Studio Web

Validate Workbook Template

Validate Workbook Template

by Kunal Hore

2

Snippet

Downloads

<100

back button
back button
carouselImage0
next button
next button

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

Publisher

Kunal Hore

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0

Updated

December 14, 2021

Works with

Studio: 21.10.4 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings