Copy data from n Number o excels in different column of Data Table

datatable

#1

I have n number of excel files having same column say “Name”, now I want to pic each file and copy their respective column in different columns of a data table is this possible?


#2

Hi @prankurjoshi,
Here i have attached a sample project for your sitiuation.

It has the folder that is having the xl files.

File : Copy data from n Number.zip (29.1 KB)

File 1

image
File 2 :
image
File 3 :
image
File 4 :
image

Regards
Balamurugan


#3

Thanks