Can‘t’ read merged cells

excel

#1

UIPath can read the numbers in “G2”, But can’t read “F2”.

2131

How can I solve this?

test1.xlsx (8.7 KB)


#2

Without diving deep into code - it’s not solveable. Merged cells are an Excel trick - it internally redirects calls to the parent cell.
So in your example from actual file perspective only columns A, D and G have values. B-C and E-F only have a redirect clause that Excel uses to display them differently and give an “inherited” (from lack of a better word) value.


#3

Then I have to find another approach.
anyway ,thanks for your help!


#5

as @andrzej.kniola said

Merged cells in excel are read by their first cell address. You should be able to pick up merged cell D2:F2 as D2

Regards…!!
Aksh


#6

It worked !
Thanks~