Strict Option late binding issue

Help Activities
, , , , , ,
1

String.Join(Environment.NewLine,readCol.AsEnumerable().Where(Function(r) r(col.ColumnName).ToString<>“” Or r(col.ColumnName).ToString<>" " Or r(col.ColumnName).ToString isNot Nothing).Select(Function(row) row(col.ColumnName).ToString).ToArray())

Hi

I’m using this expression to copy columns data and follow the same loop for each column but when I’m using the above expression getting an error strict option disallows late bindings.

image

2

@Naman_Arora

Welcome to the community

Looks like you did not change the type argument in your for loop Properties to System.Data.DataColumn…Can you please change it and check

cheers

3

Hi @Anil_G

Thanks for quick response.

I am using Set to clipboard activity to copy column data to string and follow the same loop for other columns. So Should I switch it to assign activity to record the list of data.

Regards
Naman

4

@Naman_Arora

You need not switch the activity…you can use as you need…

But I believe you are looking theough dt.Columns in a for loop and your item name is col….in that for loop you have to change the type argument to datacolumn…By default it would be object…

Cheers

5

Hi @Anil_G

I’m still getting an issue.

So let me know if we can connect anytime ?

I have few more questions

Regards
Naman

6

We would recommend breaking it down at least for the analysis purposes

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

Also we can shorten the empty check

Where(Function (r) Not ( isNothing(r("ColName")) OrElse String.IsNullOrEmpty(r("ColName").toString.Trim)))

Sounds also that the intention and the coding approach is divergent