Is it possible to read the data from different sheet in excel file

Learn Academy Feedback
, , , ,
#1

Hi,

Is it possible to read the data from different sheet in excel file? I have an excel file in which there are 3 sheet with data. I want to read the data from each sheet and create a pdf file with the data. Could anyone help me to read each sheet from excel file using Uipath.

Thanks

#2

Hi @sreeprasad,
Using the Read Range Activity . you can able to read the data and stored into datatable.
Either you can do it in loop or separate three read range activity. like

Sample file : data from different sheet in excel file.zip (8.2 KB)

image
image.png589×728 13.4 KB

To Install the word package like the below image.

image
image.png1244×577 33.5 KB

Regards
Balamurugan.S

#3

Hi Balu,

I couldn’t find the Word activity package. how to add that in Manage packages?

Thanks.

#4

Thanks Balu,

The above solution helped me alot and I’m able to convert it into pdf. Thank you so much. In my same sheet it has image as well. I mean data and a image in the file. Is it possible to include the image in the pdf file when we create it ?

Thanks.

#5