dynamically reading excel files

[#1]

i have a scenario :

there are some excel files wsr (weekly status reports) generated on every monday and are loaded on sharepoint site ,

my requirement is that qlikview should directly read the files from the sharepoint path and according to that generate report ,and the new files contains the new data along with the old data (of orevious week as well)

so logic should be written accordigly,

kindly help and guide for the same.

[Anonymous]

It would be same excel file with updated data or different file??

[Anonymous]

check this as well:

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

Load multiple excel files from Multiple excel sheetsinto QV

Load Multiple excel sheets using For loop

[ajsjoshua]

hi,

Try with qlikview optimization

[#5]

same excel file with just date changed

[Anonymous]

Okay, you mean to say new Fileds as well?

or same column with new data?

[Anonymous]

If it is , same field with new data...

Then it is QV basis functionality, make the connection once in QV..

Then schedule it eithrt at QMC or by Batch File, every time on reloads it will automatically fetch the updated data.

Is this you are asking?

[Anonymous]

check this, hope you will get your answer:

How to get updated new fields data into qlikview without editing the script manually

Refreshing Excel data tables before a load

Loading Excel file with data in Qlikview automatically

[vikasmahajan]

Dear Shivali,

Please find this thread Load excel files dynamic and check whether excel file is changed or modify if yes load into qvd‌

In this thread  Kush has answered my question which will full fill your requirement.

Vikas

[HirisH_V7]

Hi ,

One thing if the all the headers in each and every excel file in that folder .You can fetch them by,

AllTablesData:
Load *

From
[FolderPath\*.xls]

Your data will be fetched daily.if you run the application on Daily Basis on QMC or thorugh your Batch file like this,

https://community.qlik.com/docs/DOC-8899

HTH,

Hirish