How to write auto increment for Columns?

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

1 Like

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

1 Like

So you wanna read all columns from all the Excel files or some specific columns.

1 Like

Some specific Columns

1 Like

So if that is the case we need some mapping sheet like it should have from which file what columns to be retrieved!