Read row starting from a specific cell

[d.kov]

Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell?
P.s. it's better to extract non-empty cells.



Thanks in advance.

 

[sahil_raina_91]

Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell?
P.s. it's better to extract non-empty cells.

View attachment 5812

Thanks in advance.

Approach 1) If you already know the cells : Use Get Worksheet Range as Collection in Excel VBO (Start cell = B2, End cell = G2)
Approach 2) If you need to find the cell with aaa, use Find in Excel VBO, get cell ref of that cell (eg:A2), and convert A2 to B2 using Replace function, then follow Approach 1.