Update specific cell of the excel sheet table using column name

[hemalasanka]

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?

[AshwinS2 (Ashwin S)]

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

Thanks
Ashwin.S

[hemalasanka]

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

[AshwinS2 (Ashwin S)]

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

Thanks
Ashwin.S

[hemalasanka]

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

[Palaniyappan (Palaniyappan P)]

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

[Palaniyappan (Palaniyappan P)]

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

[hemalasanka]

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