Excel - Read in list of Sheet Names from Script

joshabbott — Fri, 28 Nov 2014 16:03:19 GMT

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:

http://community.qlik.com/thread/61585

I've got a connection that works to my spreadsheet:

OLEDB

CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\TEST.xlsx;Mode=Read;Extended Properties=Excel 12.0;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False];

and then I try to use the code that is supposed to bring in the sheet names as a column:

Temp_Tables:

sqltables;

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

Is there anyone that might be able to help?

I'm attaching a sample qvw

Re: Excel - Read in list of Sheet Names from Script

maxgro — Fri, 28 Nov 2014 18:36:30 GMT

PFA

Re: Excel - Read in list of Sheet Names from Script

joshabbott — Fri, 28 Nov 2014 20:07:30 GMT

You are my hero! Thank you!

topic Re: Excel - Read in list of Sheet Names from Script in QlikView

Excel - Read in list of Sheet Names from Script

Re: Excel - Read in list of Sheet Names from Script

Re: Excel - Read in list of Sheet Names from Script