Can we use any alternative for this

[sandeshdeshpande726 (Sandesh)]

Need to extract the Emp no. and Emp name
CurrentRow(“Line Description”).ToString.Trim
i am assigning this to variable
the data table does not have header
so can we use EX:- Column3 or C
any suggestions

[postwick (Paul Ostwick)]

You can reference the columns by index. So CurrentRow(2) will be Employee Number and CurrentRow(3) will be Employee Name.

[RajKumar_DC (RajKumar Durai)]

Hi @sandeshdeshpande726,

What about below method

step 1: Read Excel with following range “C4:D4”
Step 2: Use Filter Datatable set value like below

Thanks,
Rajkumar