Insert row into Excel via UIPath

[Junhao (JH)]

Hi, I am a rookie who is trying out UIpath for automation for my work purpose.

I am trying to use UIPath to insert a new row into excel, however, I am having issues as I can only find insert column and not row even with the excel integration pack.
I have tried from the following topic - Add a new row and insert data from a other Excel- data table

However, I am getting error on the assign and invoke method to insert an excel row.
And I can’t seem to find any information on how to use the assign or invoke method and how can I use them?

Would appreciate any assistance and or where can I find the relevant information?

[SaranyaKishore (Saranya R)]

Hi @Junhao,

Can you please tell me if the row has some data or an empty row has to be inserted?

[SaranyaKishore (Saranya R)]

With reference to below post, find the workflow attached for better understanding.

Add a new row and insert data from a other Excel- data table

Hello Guys, i just want to add a blank row in a existing data table and insert some data from a other data table. is it possible that the “new added row” is always on a specific Position? Maybe the “new added row” is always the second in the data table? Thank you Regards !!

InsertNewRow.zip (7.5 KB)

[Junhao (JH)]

Hi SaranyaKishore,

Thank you for the information, it help a lot. Thank you and appreciate your information.

[SaranyaKishore (Saranya R)]

Welcome