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

excel
uiautomation
pdf
activities
studio

#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)

To Install the word package like the below image.

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.