Read multiple Excel files from shared point

[kamakshisuram]

Hi All,

I am facing problem while reading multiple files from shared point url.

I have 3 excel files in shared point. Those 3 i need to read using For each file concept in qlikview.

Can we read for each file from shared point url in qlikview?

It is working if I read 3 excel files with name seperately. but not working while I tried to read with For each file.

When I debug below code , Cursor not coming into   TRACE $(ExcelFile) .. Please help me if any body knows about this?

LET vDirAI = SPDirectory & '/Action%20Items/';

LET vFilePathAI = SPFilePath & '/Action%20Items/';

Directory $(vDirAI);

For each ExcelFile in filelist ('*.xlsx')

  TRACE $(ExcelFile);