How to cut data from one cell and paste it into another of the same excel sheet

HI All, How can I capture the data in the “File” column when the cell in the “Document” column is empty and paste it there.

Help me please!

image

1 Like

Hi @aferreira054,

You can do all this using VBA and execute this using the “Invoke VBA” activity using Uipath. This is one solution, let me know if this doesn’t work for you.

Hi
Hope these steps could help you resolve this
–use excel application scope and pass the file path as input
–use read range and get the output with a variable of type datatable named outdt
–use a for each row loop and pass the above variable outdt as input
–inside the loop use a if condition like this
String.IsNullOrEmpty(row(0).ToString)
if true will go to THEN part where we can use a assign activity like this
row(0) = row(1).ToString

–then we can use write range activity under workbook activities to write that datatable to a excel we want
hope this would help you
Kindly try this and le tknow for any queries or clarification
Cheers @aferreira054

Thank you!

1 Like

No worries
Cheers @aferreira054

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.