Importing multiple excel worksheets
aveenm293
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
Hi Akowalcz,I have attached…
Hi Akowalcz,
I have attached it back with the web page. You can find it here: https://ideascripting.com/ideascript/import-multiple-files
Hello Brian, I know the new…
Hello Brian,
I know the new code is in the Smart Analyzer. Yet, would you be so kind to post your old script here, please? I am trying to create an automated script that does not require touching SmartAnalyzer.
Do you think you could actually link the old version of ideascripting.com somewhere? Just for reference?
Many thanks
Arry