The robot has been able to successfully read excel range, filter the data-table and output the row containing the desired information. However, how EXACTLY do I get the desired number? I need this desired number to be acquired as a variable to be written into another document.
Appreciate all solutions to have step by step instructions from start to finish, because I am still a noob Test get excel value.zip (5.1 KB)
You can use lookup datatable to get the row index where the value is “Value released to date” one you will get the row index using that you can get the “2163214” using
–with a ASSIGN activity like this str_output = Datatable.Rows(rowindex)(columnindex)
or str_output = Datatable.Rows(rowindex)(“columnname”)
dtRawData.Rows(dtRawData.RowCount-1)("Column2").ToString
which will give you this
dtRawData.Rows(dtRawData.RowCount-1) gives you the last dataRow
and (“Column2”) gives you the amount column
so combine them and you get amount of last row
However it is stange how the singular term RowCount works for 1 laptop (with latest ver of Studio), but for another laptop (with 2020 ver), i had to use the plural term row.counts to get it working.