How to extract complete DataRow given using Linq?

Help Something Else
, , , , , ,
1

image
image816×138 32.9 KB

I want extract complete “skills” row value one by one from excel using Linq.

how to achieve this ?

2

Hello @Muralikrishna_Surve ,

How do you want the output to be? In Array or in DataRow?
Please specify.

1 Like
4

I want output in Array.

5

hello @Muralikrishna_Surve ,

Assuming that Index for Skills row will always remains same in the excel file, you can try the below :

  1. Use ReadRow and read the Skills row item (store in myReadRowOutput )

  2. Use Assign acitvity
    MyDataArray | DataType: Array(of String)

MyDataArray = myReadRowOutput.Select(Function (x) x.ToString).ToArray()

Regards,
Rohith

1 Like
6

Thanks @rohith.prabhu .

Can you also share solution for output in DataRow ?

7

@Muralikrishna_Surve - Please try it yourself. If you face any issues please let me know, will help.

8

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