How to write auto increment for Columns?

Help Studio
, ,
1

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

2

For Each through the files

  • Read range into datatable
  • merge into final datatable
    //end for each
    Write Range to one Excel file
3

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 !

4

yes but all the column names are different

1 Like
5

What do you mean by this please ?

6

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
7

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

1 Like
8

Some specific Columns

1 Like
9

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