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

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

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)

To Install the word package like the below image.

Regards
Balamurugan.S

Hi Balu,

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

Thanks.

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.