topic Load Excel from Onedrive in QlikView

Load Excel from Onedrive

Wed, 25 Nov 2020 16:16:04 GMT

Good Morning,

I am new to this forum and would need someone to help me.

The problem is that at the time of reloading the script, the Excel of which it feeds are in a shared folder in One Drive, since these Excel suffer constant modifications by different users, I do not have to do it with the route of my computer because The Qlikview file opens on different computers as well.

Could someone help me to perform this operation from the same script.

Thank you very much

Re: Load Excel from Onedrive

avinashelite — Mon, 22 May 2017 07:41:38 GMT

You mean the source files will get updated constantly and you want to load that files ? if that is the case set the refresh frequency and give the absolute path of that shared folder

Re: Load Excel from Onedrive

Mon, 22 May 2017 11:36:05 GMT

But the file is also opened on other computers so I can not put the absolute path

Re: Load Excel from Onedrive

Siva_Sankar — Tue, 23 May 2017 01:51:31 GMT

Antonio,

Onedrive connector is available, you can use that to pull your data. OneDrive files

Siva

Re: Load Excel from Onedrive

Anonymous — Tue, 20 Jun 2017 19:58:18 GMT

Do you know how you would locate the file id of an Excel file saved to OneDrive? The Qlik OneDrive Connector requires a file id to be entered and I can't seem to find it. Thanks