Importing multiple excel worksheets
Forums
Hi Brian
I am currently using IDEA 8.5. I have 1000 excel files (.xlsx) each named differently with different sheet names (1 sheet per workbook). I have all these excel files stored in one folder.
I am looking for a script that will allow me to import all at one go as opposed to importing them one by one.
Thank you in advance.
Regards
Aveen
Import Escel Files
Hi Aveen, try out this script. It will open with a dialog to select the directory that contains all your excel files. It will then import all the xls files in the directory. It only imports the first worksheet from each excel file. Let me know if this is what you are looking for.
Hi Brian
Hi Brian
It's perfect and works great. If possible can you maybe download the one from CaseWare site and upload for me? Also is it possible that when importing a file and you haven't checked "First row is field names" that once imported you can make the first rows the field names without re-importing?
Thank you
Regards
Aveen
Multiple Files Import by Caseware
Hi Aveen, I have attached the ideascript developed by Caseware to import multiple files. It is more comprehensive then the one I gave you as it can handle different file types.
For your second questions, the only way I can think of to do this is first go to the Field Manipulation and change the field names to what is contained in the first row. Then perform an extraction using the following forumula: @Precno() > 1 - this will extract all the records except the first one. It might be quicker to reimport the excel file but if you don't have access to the file any longer these steps will give you the same thing.
Hi Aveen, there is a file at
Hi Aveen, there is a file at the IDEA web site http://ideasupport.caseware.com/ideascript/downloads/default.aspx called Import Multiple Files that might work for you. Can you let me know if it works for you or else I can create something for you.