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.
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.