Update specific cell of the excel sheet table using column name

Hi Guys,
I have a data table in excel sheet. It looks like this

I want to update the selected cell value. I can use WriteCell activity for that. So I can add WriteCell’s Cell value as like this for updating it.

D3

It works perfectly. But I have the row number(3) and I want to use column name(Join Date) instead of use “D”. How can I do that?

2 Likes

Hi @hemalasanka
Set the range as " F1:+"F+datatable name.row.count.toString

Thanks
Ashwin.S

1 Like

@AshwinS2 I have the column name. So how can I update the cell without using “F”?

1 Like

Use datatable.rows(“column name”)(row). ToString

Thanks
Ashwin.S

Thank you @AshwinS2. Above one is not working. I have edited the question again. Can you check that again and help me?

2 Likes

Fine
Kindly follow the below steps buddy
–use excel application scope and pass the file path as input
–use read range activity and get the output as variable of type datatable named outdt
–use a assign activity like this
outdt.Rows(1)(“Join Date”) = “the value you want to pass”
–use write range activity with the property Add headers enable in the property panel and pass the outdt as input

Cheers @hemalasanka

2 Likes

Use kill process with process name property as “EXCEL”
That would work for sure buddy
Cheers @hemalasanka

2 Likes

@Palaniyappan
Yes. It works perfectly. Thanks a lot.

2 Likes

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