Read file excel comma (, )?

File1 :

File 2:

If I want to read file1 and get data from file1 to read row Column C for read data in column B.

Please guide me about it.

이 소스가 당신의 질문에 맞는 결과인지 확인해 보십시오.

TEST.xaml (10.4 KB)

@sumouse No,
I want to read by rows from file1
I want compare to file2 (Find Column No. = P1) and get data in same row in column File Name


Example : first row file1 = P1
I want to find data in Column B(File Name) = Eng

I want output ENG

Please guide me about it.


Hope the following helps you. (3.1 KB)


Hi @Maria99

Try using multiple for each row in datatable

And second row(“ColumnC”).tostring.split(“,”.tochararray)

And based on the condition validate


나의 소스 Test.xaml에는 당신이 원하는 결과가 들어있습니다.
p1인 경우,
ENG를 출력합니다.

1 Like

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