Update Excel Record

Vincent_Nuestro · May 17, 2021, 12:52pm

Hi,

I want to update my excel record based on the status

I have column A and Column B
if Column A is ACTIVE then I must update the Column B and Write/Change the status to “UPDATED”
if Column A have “Inactive” record I must remove the entire Row.

How can i do it?

prasath_S · May 17, 2021, 1:20pm

Hi @Vincent_Nuestro

Read the data from excel and store it in a datatable.

use invoke code activity and click Edit Arguments,

click edit code and paste this code,

foreach(System.Data.DataRow dtRow in dt1.Select("[Column A] <> 'Inactive' "))
{
	if(dtRow["Column A"].ToString().ToUpper().Trim() == "ACTIVE")
	{
		dtRow["Column B"] = "Updated";
	}
}

select CSharp from invoke code property

and at last use write range activity to write the datatable.

Thanks

yazici75 · May 17, 2021, 1:28pm

I did something like that in my process. However, I had used an template excel and i created a conditional formatting formula in excel side. I assume this is the easiest way