You would probably get more responses with more information.
- Describe the file names and their location (all in a single folder, in a recursive tree, etc)
- Are the sheet names known or must they be read from the file?
- Do the sheets all contain the same information or loaded into the same target table?
1)File names are in same folder(Ex: Expense(folder),expense_Apr2017,expense_May2016(Excel filename))
2)for Excel expense_May2016 sheetname are A,B,C,D
for Excel expense_Apr2017 sheetname are A,B,C,E,F
(Excel Sheetnames are not known..it should load dynamically)
3)All the sheets contain same information
Ya i tried this..I list the available sheetnames in excel & used for loop to get all sheet names ..but while loading the excel file Excel expense_May2016 i get error msg like Sheet name E & F not found..similarly while loading the excel file Excel expense_Apr2017 i get error msg like Sheet name D not found..Is there any other to solve this issue