How to read an excel which as merged cell as columns

[karthik_kulkarni1 (karthik kulkarni)]

Hi ,

I need to read the excel which has merged cell as column names, and if you see from the below data if I want to read the value of national-dynamic how can I read.

	National		State		City
key	static	dynamic	static	dynamic	static	dynamic
1234	kk	mm	ss	jj	qq	oo
5678	kk	kk	kk	kk	kk	kk

[Areej_fatima]

Try these activities

BalaReva.Excel.Activities

Hi Friends, I have included some new activities that merge and unmerge the cells Name Space : [image] Merge Cells - Merge the cells inside the excel file. Properties : [image] Sample File : MergeCells.zip (24.9 KB) UnMerge Cells- Unmerge the cells inside the excel file. Properties: [image] Sample : UnMergeCells.zip (24.8 KB) Let me know if you have any errors. I would be happy to get more suggestions Regards Balamurugan.S