Im trying to read the SharePoin online excel spreadsheet data via Qlikview web files wizard we are getting 403 forbidden error

[venkatasuresh]

Im trying to read the SharePoint online excel spreadsheet data via Qlikview web files wizard we are getting "403 forbidden error"

Can you any one help me how can i extract the SharePoint online data to qlikview?

Thanks in advance,

Suresh.VV

[avinashelite]

check this

Import Excel File from SharePoint to QlikView without writing Job

[venkatasuresh]

Hi Shiva,

we need to extract the SharePoint Online Excel file not a list can you have any idea

Thanks,

Suresh.VV

[venkatasuresh]

Hi Avinash,

I need to read Sharepoint Online Excel

Thanks,

Suresh.VV

[Anil_Babu_Samineni]

Is this Sharepoint looks like Pagination / Attachment? I've done with the Pagination. But, i am not sure what your intend to prove here

[venkatasuresh]

Hi Anil,

Issue:

Qlikview unable to read the SharePoint excel online data

Step1:- We are trying to read the data from the bellow URL

https://collaboration.sharepoint.com/sites/SS245/AB911/_layouts/15/guestaccess.aspx?guestaccesstoken...

Step2:- We are hitting the URL from Qlikview Studio -->opening the web files-->internet file (copy the URL) and click the next button

Step3:- While we hitting the SharePoint online excel we are getting 403 forbidden error message

[Anil_Babu_Samineni]

Q) I need to know does this Excel situated in Sharepoint That's Fine then My question is is that file is like as attachment at URL or simple Pagination like below. Please confirm this so then we can go ahead

[buzzy996]

ok, do u have the idea wht is the ddifference between Online Excel file and list on sharepoint?

in my view(for extractor into QlikView),we can make the list as online excel by selecting the radio button as said on my previous post can pull it the live data. u can

[venkatasuresh]

Hi Anil,

Thats not a page negation we need to read the data from office 365 online excel. PFA...

Thanks,

Suresh

[venkatasuresh]

Thank you Shiva,

Im bit confused on your replys,

If possible can you give your contact number i will contact you

Thanks,

Suresh. VV

[vardhancse]

https://support.office.com/en-us/article/Synchronize-a-SharePoint-2010-list-with-Access-2010-975bfb9...