Can‘t’ read merged cells

Help
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 Likes
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

2 Likes
6

It worked !
Thanks~

1 Like
7

Hi @zsdrcdsq,

This will be useful …

Regards
Balamurugan.S

1 Like
8

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

9

Hello @yogeswaraj,

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

you can get the package from here.

https://go.uipath.com/component/balareva-xl-activities

Regards
Balamurugan.S

1 Like
10

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

11

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
12

if there a way to identify if the excel has any merged cell?

2 Likes
13

Hi @ANSHUL,

Check this one !

Regards
Balamurugan.S

15

ignore my post, coz I mixed up with Excel package…Then I realised you are referring to EasyExcel