Write into specific cell in an excel sheet

Help
1

I have an excel sheet.PAKISTAN CHILDERNS HEART FOUNDATION.xlsx (39.7 KB)
I am retrieving a specific name from a pdf file. I am comparing that name form the names in the excel sheets if it is present then I want to change the usage charges only of that person.
How should I do this.
Extract_PDF.xaml (24.2 KB)
This is my workflow so far.

2

You can use Read Range and with the datatable you will use Lookup DataTable to find that row you want to change a cell of, after you discover which row index you need, you can use assign activity like this: myDataTable.Rows(IndexFromLookup)("ColumnName") = MyNewValue

1 Like
3

I tried that but could not get it right if you can send me a sample. It will be really helpful.

4

You can also use Write Cell activity to update the value after successfully getting the rowIndex.
Just add 2 to the row number if AddHeaders is checked. in the Read Range.

image

Please note that column ā€œEā€ represents the charges column.

1 Like
5

Thanks man I will try it out