Skip to main content

Importing multiple excel worksheets

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
 
 

akowalcz Sat, 10/12/2024 - 18:15

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