I need to extract a similar column with different items for 10 excel files and add all the extracted data in single excel file with different header names
For Each through the files
- Read range into datatable
- merge into final datatable
//end for each
Write Range to one Excel file
You mean to say you have some columns defined & you want to read those columns from different Excel to write it to a consolidated Excel !
yes but all the column names are different
What do you mean by this please ?
10 excel files has different columns i want to extract the first columns from each excel and write it in another excel file
So you wanna read all columns from all the Excel files or some specific columns.
Some specific Columns
So if that is the case we need some mapping sheet like it should have from which file what columns to be retrieved!