Reading from a spreadsheet

There are times when we need to read data from an Excel spreadsheet, and in many cases, this data comes from a single worksheet inside it. The QlikView wizard creates something similar to this:

FROM
[..\QlikView Unlocked Data Chapter 4.xlsx]
(ooxml, embedded labels, table is [Sheet1]); 

This is fine, but if the user decides to tidy up the spreadsheet and give the worksheet a name, it will stop the script from running. However, if we remove the ", table is [Sheet1]" part, it will still work fine:

FROM
[..\QlikView Unlocked Data Chapter 4.xlsx]
(ooxml, embedded labels); 

This would happen as long as the data is still on the first worksheet. This just builds in a little extra bit of resilience.

You can also read multiple files ...

Get QlikView Unlocked now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.