Unable to paste text in excel

Help Studio
1

Hi All,

I am copying certain data from application and pasting in excel. That data when i copy manually in excel its working fine and all data pasted in all cells of excel.

But when i tried to use send hot key activity, it is pasting data in one cell.

Do i need to keep my excel file open for this always.

Please assist me.

Regards,
Gaumzy

1 Like
2

Hi @gtmmannd ,

Try this in the excel

Regards
Balamurugan.S

1 Like
3

Hi Bala,

I installed this package but unable to get this activity.

Regards,
Gaumzy

4

Hi @gtmmannd,

While copying and pasting table data in a excel data will get converted into string and it will get pasted into cell. So instead, please try to add the data to datatable and using write range write the data to excel. So the table format will be preserved.

Happy helping,
Arun Vignesh S
He who serves the most, reaps the most

1 Like
5

Hi @gtmmannd,

Check this video …

Thank you
Balamurugan.S

2 Likes
6

Hi Bala,

I am unable to get Easy excel package. Is it removed?

Regards,
Gaumzy

7

Thanks Arun. I am checking on this.

Regards,
Gaumzy

8

Hi @gtmmannd,

Check it here.

image
image1125Ă—682 84.6 KB

Thank you
Balamurugan.S

1 Like
9

Hi Bala,

I have again checked. We are using enterprise edition uipath 2018.4.6. But we didn’t get this package in Manage Packages section. We only got Bala reva Excel activities. Apart from this we didn’t get any packages. I am not sure about the reason.

Thanks for assisting me.

Regards,
Gaumzy

10

Hi Arun,

Data was not in structured form. I created datatable by text and used write range. But bot was missing so many things while creating datatable. So after write range activity final excel is not giving desired value.

Thanks for assisting me.

Regards,
Gaumzy

11

Hi @gtmmannd,

You this search keyword in the search box: balareva.easyexcel

image

Thank you
Balamurunag.S