Read cell and row

[Crusha (CH)]

Hi,

I have several values ​​like in the following Excel table. For example, I have given the values ​​3 D and would like to read the value from the column with the 3 and the row with the D. What function can I use to read it? Read row in connection with read cell? horizontally & vertically ==> “dolore”

[Yoichi]

Hi,

Hope the following helps you.

In this case, add header option of Read range is false.

Regards,

[Crusha (CH)]

What should this do? → dt.Rows(asc(r)-65)(Clnt(c)-1)

[Yoichi]

Hi,

dt is output of ReadRange activity. (DataTable type)

Regards,

[Crusha (CH)]

Can please send me your .xaml to this solution? My variables dont work with your example.

[Yoichi]

Hi,

Can you try the following?

Sample20200611-2.zip (16.3 KB)

Regards,

[Crusha (CH)]

@Crusha

Clnt

thx
i has a problem with Clnt its works now perfect, thx you!