topic Re: Multiple excel with multiple sheets loading(sheets names are dynamic) in QlikView

Multiple excel with multiple sheets loading(sheets names are dynamic)

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

I have 3 excel files in one folder with same column names, i want to load all sheets data from all excel files.

Here i don't want to connect any data base for excel files and my sheet names are Dynamic.

Here i am attaching my excel files.

Regards

Mahesh

devarasu07 — Wed, 25 Oct 2017 03:05:27 GMT

Hi,

have you tried this for loop method

qlikview979 — Wed, 25 Oct 2017 04:01:24 GMT

I tried that,i am not able to achieve that. if its possible prepare a sample app with my attached data.

-Mahesh

qlikview979 — Wed, 25 Oct 2017 07:13:07 GMT

Hi Experts,

any one can help me on this.

-Mahesh

jonathandienst — Wed, 25 Oct 2017 07:27:08 GMT

You will need to loop over the files using the above selections and in each, loop over the sheets using the solution here Need Help with loading multiple sheets of an Excel file

Kushal_Chawda — Wed, 25 Oct 2017 07:37:58 GMT

try like below,

Just define your excel file pathand QVD path.

qlikview979 — Wed, 25 Oct 2017 08:45:48 GMT

Hi All,

Sorry for delay.

My Machine doesn't have Qv right now, if its possible can any one share script along with my all files data in table box.

-Mahesh

qlikview979 — Thu, 26 Oct 2017 05:25:21 GMT

Hi Kush bro,

I defined my excel and qvd path, then i go for reload its showing below error

Here i am sending my files with qv app.please check and let me know where i am wrong.

Regards,

Mahesh