Connect HomeMarketplaceComponentsColor Cells with Invalid Special Characters

Color Cells with Invalid Special Characters

Snippet

Snippet

Updated: October 3rd, 2020

Published: August 17th, 2020

Downloads: 7

Language compatibility: Visual Basic

Community Support

Color Cells with Invalid Special Characters

Snippet

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

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.


Details

Benefits

This Snippet helps in finding cells with any special characters except for the specified ones and colors them.

Compatibility

Compatible with all Studio versions starting with 2018.4.1.

Dependencies

UiPath.Excel.Activities
UiPath.System.Activities

Resources

- User_Guide.pdf

Licensing

By clicking download you agree to the following license.