Importing Multible Excel Files with multible tabs

2 posts / 0 new
Last post
emad.alphonse@i...
Offline
Joined: 10/01/2020 - 13:43
Importing Multible Excel Files with multible tabs

Hello,
I am looking for an IDEA Script that will automate the importing of multiple Excel files in the same folder, each file has multiple tabs with different name for each tab. Ideally, the script will also add the file name, and the Tab name as well to each imported file, then append all the imported files into one .IMD file.
if you can reach me by email, I will really appreciate it: emad.alphonse@irs.gov

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Emad,

If you have access to passport and are on IDEA 11 you can download the utilities smart analyzer application as there is a multi-file import in there that allows you to import multiple excel files with multiple worksheets.