Strict Option late binding issue

[Naman_Arora]

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.

[Anil_G (Anil Gorthi)]

@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

[Naman_Arora]

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

[Anil_G (Anil Gorthi)]

@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

[Naman_Arora]

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

[ppr (Peter)]

@Naman_Arora

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())

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)))

@Naman_Arora

I’m using this expression to copy columns data and follow the same loop for each column

Sounds also that the intention and the coding approach is divergent