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 ...