How get specific value from an excel sheet (part 3) included my working example, pls advise

[Chaaza (Chaaz)]

I have attached my working file. The goal is to obtain this number at the end of the excel sheet:

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)

[Sanjit_Pal]

Hey @Chaaza,

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”)

Thanks,
Sanjit

[jack.chan]

here
Get value attempt 1.xaml (9.1 KB)

after read range just do

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

[Chaaza (Chaaz)]

Dear Jack,

thanks for the prompt solution. Unfortunately I get this error when i try to get the amount with a write line:

dtRawData.Rows(dtRawData.RowCount-1)(“Column2”).ToString

How do I fix this?

[jack.chan]

Replace RowCount with Rows.Count @Chaaza

[Chaaza (Chaaz)]

Thanks Jack.Chan that worked!

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.

[jack.chan]

yes it depends on the version . newer version allows rowCount , old version only allows rows.Count