Can‘t’ read merged cells



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


How can I solve this?

test1.xlsx (8.7 KB)


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.


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


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



It worked !