Read All Excel Files From a Folder
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
Can someone help me out with a Solution. I want to read all the Excel Files from a Folder at once. All the files have the Same Structure and has only one single Sheet named Report. I tried with a macro but the sheet name is not coming up. Please assist
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If they all really have the same structure, setup a single data input tool to read one of the files with the correct sheet name, then change the name to a wildcard. Instead of c:\filelocation\yourfilename.xlsx make it c:\filelocation\*.xlsx
That should grab all files in that folder with an excel extension and open them up.
If there are any errors about schema, then a macro would be your best option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @DataPirate26
Dear , As @SPetrie said, If your all xlsx file have same schema and only for one sheet name, you just use a wildcard to cover all xlsx file name in path by C:\abc\123\*.xlsx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
