Help in reading multiple excel files

Eug_teng

I have multiple excel files, each with 3 sheets as seen in the attached files.

1. I only want to import the 1st sheet of each excel file (NOT Sheet 1) using the * wildcard since the excel files are all downloaded into the same folder. 

2. The format and fields of the 1st sheet of each excel file are the same!

However, the sheets are named differently. How to I go about doing this? 

Thank you!

B.xlsx

A.xlsx

C.xlsx

messi007

@Eug_teng,

Blow the batch macro that will allow you read the first sheet.

Do not forget to replace the the schema in the input file and dynamic read if your inputs are not in the same folder as the workflow

Below the workflow

Attached the workflow,

Hope that helps,

Please mark it as a solution if it solve your request 🙂

Regards

ReadFiles.yxzp