How to read excel data where columns are merged

[T_Y_Raju]

I have data in excel where in some columns data have been merged

like A and B columns have been merged

i want to read the row(0) value and get the corresponding row(1) value here

problem is since both a and b columns are merged can i get the values as expected
or is there any other solutions

[Palaniyappan (Palaniyappan P)]

Refer these and let us know if u r looking for something else

In this video u can u merge and read simply as a datatable with read range

Uipath excel Merge and Unmerge cells activities (BalaReva)

Or

How to fetch same cell value for all merged cells

Hi All, I have the data as shown below [image] And I need the datable as below. [image] Is that possible? Using read range and writing to the data table is not helping, A6, A7 and A10 are coming blank that way

@T_Y_Raju

[T_Y_Raju]

this is bala reva package right

[Palaniyappan (Palaniyappan P)]

Yes that’s right
Most commonly used @T_Y_Raju

[supermanPunch (Arpan)]

@T_Y_Raju

problem is since both a and b columns are merged can i get the values as expected

Hi @T_Y_Raju ,

Is it possible to provide a Sample Excel data and the Output that you are expecting, we could derive the methods for accessing the Merged data as when read using Datatable, the Data always gets stored in the First Column of the Merged Cell. So we could access the values accordingly in that manner.