Skip to main content

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 Tue, 04/13/2021 - 19:03

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.

karlfmullen Mon, 11/08/2021 - 04:39

Hi
I have a script which imports the first sheet in an excel file. When the script is run is asks you to select the relevant excel file from the source files folder of your current project. In each case I am only importing a single file.
Is there a way to import all the worksheets from the selected excel file and not just the first one?
Thanks
 
karl
 
 

Brian Element Tue, 11/09/2021 - 10:52

In reply to by karlfmullen

Hi Karl, for that functionaly you will need to have IDEA 11 installed.  Then go to the passport support site, select the Smart Analyzer tab and then download and install the utility Smart Analyzer app.  In there you will have the multi-file import that does have that functionality.