Check if excel file exist

[Anonymous]

Hello qlikers 🙂 ,

I want to check if an excel file exist or not.

LET vExistQVD=isnull(QvdCreateTime('Test/File.qvd'));    //works
LET vExistFile = isNull('Test/File.xls');                //works not

The script snippet for check if the qvd exist works, but not the other code snippet.

How can I check if there file exist or not ? Thank you in advance! 

[Rodj · Accepted solution]

Try:

if IsNull(filesize('[lib://Yourdata/YourFile]')) = -1 then

  SET vExistFile ='false';

else   

  SET vExistFile='true';

endif;

That's how it's done in the Qlik Deployment Framework and worked for me just now in a quick test in desktop.