I have an excel sheet with a set of column names and multiple excel sheets with same values but different column names. for eg.( Name, Full Name,etc). how do i append the column from all these files to the first file in a for each loop?
Do the Indexes of the Columns remains Same for all Excel sheets( Eg: index of column “Name” in 1st sheet is 0, then is the index of column “full name” in the other sheet also remains as 0.
If the format of all the sheets is same and the indexes of the columns remains same then you can use Merge DataTable.
Its not and i have to append a list of excels to the 1 original excel
@MAHESH1 when i assign column names to a data table with or it gives me the following error
where testRow1 is the original file and i am assiging it to a diff datatable value.