topic Re: Looping Excel files with Sheets in QlikView

Looping Excel files with Sheets

Anonymous — Mon, 26 Mar 2018 09:52:37 GMT

Hi Friends any suggestions on the below query:

I am trying to load Excel files with Jan, Feb......Dec as sheet names.

There are 3 Excel files in the Folder with Month names as sheet names. Naming convention is like below:

Filename: Data2010.xlsx with Jan till Dec sheets.

Can anyone suggest how to loop and load these Excel files please.

Thanks in advance.

Re: Looping Excel files with Sheets

tresB — Mon, 26 Mar 2018 09:57:28 GMT

Have a look here:

Load all Excel files and all sheets in a folder

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

Re: Looping Excel files with Sheets

Anonymous — Mon, 26 Mar 2018 11:09:23 GMT

Hi Tresesco, i am using the same code , but there is some problem while code execution , if iam not wrong the next i and next or there should be a drop table some where , coz for me if i use the code as it is it is giving me 12 months (Jan to Dec sheets ), 24 months and 36 months . can u suggest please.

Regards