Need ideas updating in Excel

Help Activities
,
1

Hi,

I need to create a solution where I lookup a value in Excel. If that value Exists, i need to update the row. If it doesn’t Create a new row.

Creating a new row is pretty easy and straightforward as i’ve done it multiple times, by creating an array and DT and adding the array to the DT and the writing this to Excel.

How would someone go on to Look up a value in a specific column and get the Row? Is this even possible with Excel activities or would you recommend reading the Excel in a DT and then doing lookups on the DT? What are the options? Kind of lost rn.

2

@okan_mutlu,

UiPath do have native excel activity solution for this. Activities - VLookup

Thanks,
Ashok :slight_smile:

3

Use For Each Excel Row. Check the value with CurrentRow(“columname”).ToString and if it’s the value you’re looking for, add to the datatable. After For Each Excel Row has completed, use Append Range to add the rows.

4

@okan_mutlu

you can use lookup range under excel activities if you want to do this directly on excel

if not read the data into datatble and use lookup datatable and add the new rows and then write the data back to excel

both the ways would work

cheers

5

Lookup datatable does it for me, thanks

1 Like
6

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