Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Error Mode = 0 not working with Excel 2010 file when sheet is missing

Hi everyone,

While looping a folder with Excel documents in load script, I'm having trouble trying to ignore an error when a sheet doesn't exist in one of the files. I have the ErrorMode = 0. The script finishes anyway and pops up the reload message box. The files are from Excel 2007/2010. Is it really the missing sheet that is causing the problem? Ther is no way of knowing what's going on and that's extremely frustrating! I can't use the sheet number because it has different content across documents: only the sheet name can be used. I'm using version QlikView version 10 32bit.

Anybody with similar problem?

1 Reply
Highlighted
Partner
Partner

Error Mode = 0 not working with Excel 2010 file when sheet is missing

Hi,

In Rob's Cook Book ( http://robwunderlich.com/downloads) there is a example of load using ODBC. This way you can check all the sheets that exist before trying to actually load them.

There are many more great examples in that page

Hope this helps,

Erich