How do I get values for specific columns and rows in Excel?

Asked 2 years ago, Updated 2 years ago, 61 views

Regarding the subject,
If you have a table,
There are several rows of values in the table.
What I want is not column A, but column B, second row and subsequent cell values.

Loop with For Each and exit when the line is empty.
Repeat

DimdtRowsAsdatatable 
Foreach dtRows in Keywords.row
   String.isNullofEmpty(dtRows.item("value").ToString())
Next

"Value" = B2 cell.
I would appreciate it if you could tell me how to get it from the loop above.

excel vb.net rpa

2022-09-30 16:10

1 Answers

Sorry.

Self-resolved.

It's not a code issue, but
Excel had a wrong sheet to retrieve parameters.


2022-09-30 16:10

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.