Hi all,
I want to read a particular value in an excel-like $1234 . Here it is $1296.35 as per the excel attached
pls let me know how to read it. Any suggestion are welcome.
1 Like
1 Like
If it is always the same row and column you could use the uipath.Excel.Activities.ExcelReadCell activity and fill in the sheetname and cell
if it is dynamic but you know what cell and row number you could still use it but dynamicaly build the cell indicator (column.ToString + row.ToString)
If you don’t know this but it is the last row you could read the range (entire sheet, or the column) and pick the last row from your extracted datatabel
dt.rows.item(dt.rows.count-1) and then select the correct column
Hi @tbrinkman thank you
Am trying this below what you gave. but not working
if it is dynamic but you know what cell and row number you could still use it but dynamically build the cell indicator (column.ToString + row.ToString).
make sure you enter a valid column and row
so if you know it is column 3 make sure you first convert it to C
Column will be same but row may differ…il try