How to Update specific cell in a column dynamically

Help Studio
, , , , , , ,
4

@anmita

So

  1. Use the same for loop

But assign would be

Assuming month is stored in a variable(Month)

CurrentRow(Month) = 90.8

2.Read the excel data into datatable(dt)
then
Assign(Row index is String type)
RowIndex = dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x("Name").ToString.Trim.Equals("Anita"))).ToString
Assign(ColumnValue is String Type)
ColumnValue = chr(65 + dt.Columns.IndexOf(Month))

Use write cell

With cell value = ColumnValue + RowIndex
Cell data = 90.8 or “90.8”

For row index you can also use

Rowindex = dt.Rows.IndexOf(dt.Select("[Name]='Anita'")(0)).ToString

Hope this helps

cheers

cheers