Read multiple Excel files from shared point

kamakshisuram — Wed, 01 Apr 2015 07:13:20 GMT

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);

topic Read multiple Excel files from shared point in QlikView