The range System.Data.DataRow does not exist

Help Studio
, ,
1

Current row is 300 and column is “J”. I want to write data to the J300 cell (Please look at the red circle), That’s why I am using write cell avtivity and writing “J” & CurrentRow.ToString or “J” + CurrentRow.ToString but I don’t know why I am getting error of “The range System.Data.DataRow does not exist.”.It’s still the same even if I tried different . Could anyone please answer me if you know? It’s in urgent.

image
image442×164 6.35 KB

This image shows a segment of a UiPath workflow where a "Write Cell" activity is used within an "Excel Application Scope" to write the date "2025/12/20" to a specified cell in an Excel sheet. (Captioned by AI)
This image shows a segment of a UiPath workflow where a "Write Cell" activity is used within an "Excel Application Scope" to write the date "2025/12/20" to a specified cell in an Excel sheet. (Captioned by AI)1641×785 114 KB

2

when you do CurrentRow.ToString the output will be the System.Data.Datarow which is the data type of current row. To get the index of that row from dt_test (assuming this is your datatable), do following
"J" & dt_test.Rows.IndexOf(CurrentRow).ToString

3

Hey @myakkhaing go with this logic

The image shows a UiPath workflow within an Excel Application Scope that reads a range from "Sheet1," iterates through each row in a data table, and checks if the value in column "Col1" equals "Sam". (Captioned by AI)
The image shows a UiPath workflow within an Excel Application Scope that reads a range from "Sheet1," iterates through each row in a data table, and checks if the value in column "Col1" equals "Sam". (Captioned by AI)654×470 18.3 KB

The image shows a section of a UiPath workflow where a "For Each Row in Data Table" activity is used to iterate through rows, check a condition, write to a cell, and assign a row index if the condition is met. (Captioned by AI)
The image shows a section of a UiPath workflow where a "For Each Row in Data Table" activity is used to iterate through rows, check a condition, write to a cell, and assign a row index if the condition is met. (Captioned by AI)995×477 24.8 KB

A spreadsheet shows data in row 300 with "Sam" in cell B300 and "Found" in cell L300, both highlighted in yellow. (Captioned by AI)
A spreadsheet shows data in row 300 with "Sam" in cell B300 and "Found" in cell L300, both highlighted in yellow. (Captioned by AI)857×350 12.1 KB

Sequence.xaml (11.7 KB)

cheers happy learning

4

@myakkhaing

Currentrow.tostring will give the type of it which is datarow and not the index

Inside loop properties you have index property …assign a variable to it and use it

If the activities you are using are modern then currentindex variable should be auto available inside loop

Cheers