Can‘t’ read merged cells

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

2131

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.

3 Likes

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

Regards…!!
Aksh

2 Likes

It worked !
Thanks~

1 Like

Hi @zsdrcdsq,

This will be useful …

Regards
Balamurugan.S

1 Like

Hello Team
Please let me know if there is any solution to solve the merged cell issue in excel

Hello @yogeswaraj,

Welcome to UiPath Community. Here you have the activity to do the merge cell.

you can get the package from here.

Regards
Balamurugan.S

1 Like

Thanks Bala … But my doubt is how to read the merged cell data ( here in the excel the country wise data is grouped ). If I use read range excel activity it is reading the source cell data not the merged cell data. Please find the snapshot for your reference.Merged%20Cell

Hi @yogeswaraj,

I have tested your example. Actually the merge should have the value only in one cell . Not with all merged cells.

Here I have shown your example while it is in un-merged.
image

So you have to fill the empty column,.

Regards
Balamurugan.S

1 Like