How to read Data from Excel when it have Multiple Headers

Help Activities
, ,
5

@ramesh_kola

                                 1) Create a template with same header  Assume Datatable as TempDt
                                 2) Read your input excel and skip first two rows (InputDt)
                                 3) Use this query to skip two rows 
                                 Assign   InputDt=  InputDt.asenumerable.skip(2).copytodatatable
                                 4) Use Append Range for template and pass Datatable as InputDt
                                 5) Than  read append range excel