MarketplaceListingsSnippetColor Cells with Invalid Special Characters

Color Cells with Invalid Special Characters

Bronze Certified

Snippet

1 reviews

7

Color Cells with Invalid Special Characters

Bronze Certified

Snippet

1 reviews

7


Summary

Reads Input file and colors all the cells which contain any of the special characters except for those which are mentioned in the Array of String

carouselImage0

Overview

This Snippet has four arguments:

1. in_FilePath (String): Path of the Excel file for reading and colouring the cells with special characters. Required.
2. in_SheetName (String): Name of the sheet in Excel file. Required.
3. in_ColumnName (String): Name of te column to check for special characters. Required.
4. in_ValidSpclCharArray (String []): Array of String containing special characters which are acceptable. Optional.


Benefits


Published: 2020-09-01T11:25:04+00:00 | Updated: 2020-10-03T16:01:11+00:00

Trusted Source


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Tags

color cell
special-characters

Compatibility

Compatible with all Studio versions starting with 2018.4.1.


Dependencies

UiPath.Excel.Activities UiPath.System.Activities


Documentation


Similar Listings