Multiple excel files

Ganesh Dharmarajan…this is my profile name…can you send the request?

1 Like

Do you know how to take the table data from multiple Excel files?
Every excel sheet having different different records.But all column name is similar.finally all the table data combine into a single sheet.

Multiple excel files or excels sheets buddy

Multiple Excel files

Any idea?

Yes buddy you can get from a folder with n number of xlsx files with Directory.GetFiles(“your folder path”,"*.xlsx")
While this gives an array and you can iterate through each file within a for each loop

Cheers…

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.