I have a requrement to load data from a spreadsheet, and the data may be coming in from multiple tabs. If this is the case, I need to load it from all those tabs and concatenate it all together.
The obvious solution to this is to connect to the XLSX document via ODBC and do SQLTables; and then enumerate through the TABLE_NAME values.
However, we don't have office installed on our Qlikview servers, nor do we have relevant ODBC drivers installed. Installing drivers is not an option, so instead we'll have to do it programatically. I was thinking perhaps we could name the tabs sequentially (the name of the tabs is something we can control) and attempt to enumerate through tabs until some kind of error is recieved and then stop looping.
Is this something that sounds plausible, or is there a more obvious way to do this? Thanks.
