How to use Linq?

I want to read excel If column Order Type = #N/A
write text = New register In Column N
and copy data from Col B β†’ write in column H

I think if use linq , It fastest than for each row.

Please guide me about it.


There are two operations involved β†’ writing New Register text and and copying column value
Both the task are to be done only when Order Type = #NA ?

Can you share the sample excel file.

You can try the following method



The Code used is

dt.AsEnumerable.Where(Function (x) x("Order Type").ToString.Equals("#NA")).ToList().ForEach(
	row(13)="New Register"
End Sub)

Finally you can write the data table (inputDT) to the excel file using the Write Range Activity

For your reference

Change Cell Value.xaml (5.0 KB)

1 Like

@kumar.varun2 I use follow you suggest.
But after run rows #N/A is blank (column H and I)

Find attached about input as below:
data.xlsx (45.3 KB)

Please guide me for solve it.

Hi @Maria99

Try with the code below

dt.AsEnumerable.Where(Function (x) String.IsNullOrEmpty(x("Order Type").ToString.Trim)).ToList().ForEach(
	row("Order Type")="New Register"
	row("Order Date")=row("Activation Date").ToString
End Sub)


Change Cell Value.xaml (5.4 KB)

1 Like

@kumar.varun2 I have more questions.

If In Pretty Flag not = N
I want to write text β€œY” in column Result (column L) and write text β€œnot approve” in Column Recheck (column M)
File input as below: data2.xlsx (41.9 KB)

Please guide me about it.


is this different from the above or you want to add both the conditions together.

@kumar.varun2 It step2 after above case.


Simply add this code below the previous code

dt.AsEnumerable.Where(Function (x) Not x("Pretty Flag").ToString.Trim.Equals("N")).ToList().ForEach(
	row("Recheck")="Not Approve"
End Sub)

Like this

1 Like

@kumar.varun2 Last question.

If column Pretty Flag = N and in column Order Type not = New Registration or column Order Type = Change Charge Type β€”> write row(Recheck)=β€œWaiting”

Find attached about input as below:data3.xlsx (43.6 KB)

dt.AsEnumerable.Where(Function (x) (x("Pretty Flag").ToString.Trim.Equals("N") And (Not x("Order Type").Equals("New Registration") Or x("Order Type").Equals("Change Charge Type")))).ToList().ForEach(
End Sub)
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.