Is there any way to get the position of a cell from a DataRow?

Help Studio
, ,
1

Currently, I am storing Excel information in a DataTable, and using the ForEachRow activity to turn the DataRow row by row. However, I need to get the position information (A1, A100, etc.) of the cell whose column name is “AAA” in the DataRow that I am currently rotating.

【Image】
DataRow.item(“AAA”).? ＝ ”A1”
DataRow.itemArray(“AAA”).? ＝ ”A100”

I’m looking for a way to get the position of the cell whose column is “AAA” in the current DataRow using the item and itemArray methods, but I haven’t found it.

Doesn’t the DataTable contain Excel cell information?
If you know how to get the location of the currently used cell from the DataRow, please let me know.

Thank you in advance.

2

Hi @Kirigirisu_Coin,

Do you want to get the cell information for the value available in the data table. could you please add the below activity in your work flow to get the cell information. just a thought from my side.

Regards,
Kirankumar.

1 Like
3

Hi @Kirigirisu_Coin ,

Please try this package,there is an activity called search row Index, you can also find other activities for datatable which will be useful.

Thanks

4

I forgot this activity.
Thanks

1 Like
5

your most welcome.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.