How to load excel sheet to qlikview from sharepoint

[vardhancse]

Hi ,

I have a requirement is that need to load excel sheet from share point can any one help me out.

In that excel sheet i have around 5 sheets.

[#2]

Try like Below:

Let vSharePointPath = 'http://mydocuements/sharepoint/'; // Get full folder path

LOAD *

FROM [$(vSharePointPath)/ExceFileName1.xls] (ooxmal) (sheet$1);