I've been having some terrible issues trying to get this to work. I need to create a connection to an excel spreadsheet and pull the names of the sheets into a QlikView table. I've seen many examples how to do this:
and then I try to use the code that is supposed to bring in the sheet names as a column:
But this just brings back a qlikview table with 0 rows that have these columns (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, TABLE_GUID, DESCRIPTION, TABLE_PROPID, DATE_CREATED, DATE_MODFIIED, DATASOURCE).