Read Data

Help Studio
,
1

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
2

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

Cheers
@anayarogluyigit

3

thx and best regards.

1 Like