Read data from excel

[Principal_htga (Harshit Gupta)]

i have excel where i have to use data to fill application.
We have data under various category. How to read them. I am attaching excel for reference.
N522976 A45222 MFP.xls (42 KB)

[Srini84 (Srinivas)]

Hi @Principal_htga

If your template is fixed

• Use Excel Application Scope Activity
• provide excel path
  -under Excel Application Scope Activity keep Read Range activity
  -Read Range Activity will output the Datatable
• Using columns and rows you can always manipulate the Datatable and get the required info

Hope this helps

Thanks

[Sugumar8785 (Sugumar Ramachandran)]

@Srini84 please check excel file attached and suggest appropriately how to read those data.

[GBK]

@Principal_htga - There are activities designed to manage Excel in UiPath - Please go through the link for activities and sample example.

Activities - Read From Excel Files

also - pls check the link for row by row data earlier read post -

Read row by row and column by column in excel

Hi there, how its possible to read a extrem long excel List row by row and column by columns until an empty field comes ? Read Row1 in Excel the first Cell and INPUT in a Homepage. Than read the second Cell in Row 1 (Column 2) and Input this in a Homepage. Then Jump in Row 2 in excel read the first Cell and Input in the Homepage. Then read the second Cell in Row 2 (Column2) and Input As long as an empty field comes Big Thanks Erwerf

[Bhavik_Solanki]

@Principal_htga, Looking at file it seems like it’s fixed template. If so you can use Write Cell activity.