Unable to paste text in excel

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

Hi @gtmmannd ,

Try this in the excel

Regards
Balamurugan.S

1 Like

Hi Bala,

I installed this package but unable to get this activity.

Regards,
Gaumzy

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

Hi @gtmmannd,

Check this video …

Thank you
Balamurugan.S

2 Likes

Hi Bala,

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

Regards,
Gaumzy

Thanks Arun. I am checking on this.

Regards,
Gaumzy

Hi @gtmmannd,

Check it here.

Thank you
Balamurugan.S

1 Like

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

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

Hi @gtmmannd,

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

image

Thank you
Balamurunag.S