Replace a data with the particular column cell using the column name?

I want to replace a data with a new data to a particular cell of datatable using column name?

Hi @Manish540,

Can you please elaborate your topic with some screenshots or with something else?

Thanks & regards,
Apurba

Use Assign Activity,

inputDt.Rows(RowIndex)(ColumnIndex) = “yourValue”

Example:
inputDt.Rows(2)(1) = “yourValue”

Please refer this workflow for more details,

ReplaceParticularValueinDt.xaml (8.6 KB)

Thanks!

Their is already a data in a particular cell of a particular column , now I have to replace that data with new data?
I’m performing this operation inside the for each row, so i want to do this replacement to all the rows of a particular column name.?
I used row.item(“Columnname”) = newdata. but its not working or updating that column?

Just by using the column name I have to do it…

How to find the rowindex and columnindex of “row.item(“Columnname”)” of this???..

Their is any other method like… we can use regex or linq queries??

Can you share your xaml or sample Excel sheet with dummy data.

ConvertParticularDateFormat.xaml (10.4 KB)
TestData.xlsx (8.3 KB)

Hi @Manish540,

Please use Assign activity and assign like below -
row(“ColoumnName”)="ColoumnName"

Thanks & Regards,
Apurba

The section where i want to assign the newdata , i have commented out…

Its not working.

Hi Manish540,

Column names usualy dont change so u can use

YourString = “ColumnName”

Write Cell
YourString

TestData.zip (10.0 KB)

Please check this file.

Thanks!

Ya I used “OutDataTable2.Rows(i)(“Column2”) = newdata”.
It worked for me…
Thank You:smiley: everyone for your reply

1 Like

Its not opening?..

DateTimeParse.xaml (8.8 KB)

Thanks!

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