I want extract complete “skills” row value one by one from excel using Linq.
how to achieve this ?
Hello @Muralikrishna_Surve ,
How do you want the output to be? In Array or in DataRow?
I want output in Array.
hello @Muralikrishna_Surve ,
Assuming that Index for Skills row will always remains same in the excel file, you can try the below :
Use ReadRow and read the Skills row item (store in myReadRowOutput )
Use Assign acitvity
MyDataArray | DataType: Array(of String)
MyDataArray = myReadRowOutput.Select(Function (x) x.ToString).ToArray()
Thanks @rohith.prabhu .
Can you also share solution for output in DataRow ?
@Muralikrishna_Surve - Please try it yourself. If you face any issues please let me know, will help.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.