Hello Team, Kindly help me with my scenario, I have an excel where it has Multiple Headers as below. [image] and question here, it is possible to change the data table to unique column names for subheader by appending main header to subheaders? like below [image] Kindly Help me with this, Tha…

I have resolved the issue, Thanks for your all responses

How to read Data from Excel when it have Multiple Headers

ramesh_kola (Ramesh Kola) October 20, 2022, 2:10pm 3

Hi Paul,

Could please share any sample code please to understand in detail?

And in excel columns are not always side by side some cases columns might be interchanged.

Topic		Replies	Views
Excel:DIfficulty in extracting the data in Excel which has merged headers Activities datatable , excel , activities , question	9	1802	February 1, 2021
Is it possible to read the excel which have 2 or more columns with same name? Help datatable , excel , activities , question	19	5803	October 28, 2021
How to read columns that has multiple Headers Help datatable , activities , studio	4	2008	July 17, 2019
Two names of columns Activities excel , activities , question	10	525	April 6, 2023
Read Data From One Excel and Write That Data Into Another Excel With Different Column Name Help datatable	19	3832	August 1, 2020