My process loops through a folder and checks excel files for a specific sheet name “GL Queries”. If one or many is found, it then loops through them to manipulate and filter rows.
I am currently using the Get Workbook Sheets activity within the current workbook scope and outputting a list variable named list_fileSheets. I have created another variable named list_fileSheetsFiltered. Both are type: System.Collections.Generic.List<System.String>.
I am then using an Assign activity and setting it as such: list_fileSheetsFiltered = list_fileSheets.Where(Function(b) b.Contains(“GL Queries”, StringComparer.CurrentCultureIgnoreCase)).ToList.
This assign produces the following error:
Complier error(s) encountered processing expression “list_fileSheets.Where(Function(b) b.Contains(“GL Queries”, StringComparer.CurrentCultureIgnoreCase)).ToList”. Option Strict On disallows implicit conversions from ‘String’ to ‘Char’. ‘System.StringComparer’ cannot be converted to ‘System.Collections.Generic.IEqualityComparer(Of Char)’ because ‘Char’ is not derived from ‘String’, as required for the ‘In’ generic parameter ‘T’ in ‘Interface IEqualityComparer(Of In T)’.
Multiple users are naming these sheets, so I would prefer the “filter” match with strings that are in any case.