Importing Multible Excel Files with multible tabs

2 posts / 0 new
Last post
Joined: 10/01/2020 - 13:43
Importing Multible Excel Files with multible tabs

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:

Brian Element's picture
Brian Element
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.