HOW DO I WRITE A TEXT IN THE DATA TABLE BASED ON THE FIRST COLUMN DATA:-

Hi Team,

I am stuck in the really silly part in the data table.

As shown in the image, I am having reading the excel using read range.

Now this data is stored in a data table. (lets say dtExcel)

I used as follows:-

For each row in dtExcel
if row(0) = A

write “UiPath” in the row(2)

All this comparison and text writing(“Uipath”) has to be done directly from the data table.

No extra read and write has to be done for the excel sheet.

Capture

Please help me, I am stuck in this step.

Thanks and regards,
@hacky.

@hacky Here you go

Main.xaml (9.6 KB)

test.xlsx (8.2 KB)

@indra

Thanks buddy,

But unfortunately, this script is not able to run due to some versioning issue,:-1:
please find the image for the same.

Go to Manage Packages and update your packages.

Thanks,
Prankur

@PrankurJoshi,

All the local packages are been updated for me. Kindly suggest some other option.

@hacky Just used For each row see below screen shots

1 Like

Open the project.jason and check if the activity versions are matching . If you are using an enterprise version then depending upon your organisations settings and preferences you will get the latest package.

the last option would be to ask @indra for screenshot and solution explanation.

@indra.

Dude this is where I had an issue.

Please re-read my question.