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

Mon, 22 Aug 2011 12:52:32 GMT

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?

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

erichshiino — Mon, 22 Aug 2011 13:45:49 GMT

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

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

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

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