Can we use any alternative for this

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

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

1 Like

Hi @sandeshdeshpande726,

What about below method

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


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