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 using a wildcard in the name. This works with all types of files, including database tables. So, for example, you might have spreadsheets with sales data in them for each month and year. The names of each spreadsheet could be something similar to...