Read Data

Dear all,
I have an question about studio-activities.

I need to read an excel file, than I need A/C number from that excel file. I will use A/C number in another application to search A/C activities.
Should I build a data table? and Should I read excel with “For Each” Also could you give me important tips that I should be aware of? Thanks and best regards.

1 Like

Hi @anayarogluyigit,

you can do this

  • Read Range Activity, Pass the Path of the excel file and get the output as outDt
  • For each row Activity, Use outDt as Input to For each row.
  • now to search the Account number in application use Type into activity and pass this syntax row(“AccountNumberColumn”).ToString


thx and best regards.

1 Like