Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

joshabbott
Contributor III

Excel - Read in list of Sheet Names from Script

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 OLEDBSmiley Frustratedystem database="";Jet OLEDB:Registry Path="";Jet OLEDBSmiley Very Happyatabase Password="";Jet OLEDB:Engine Type=37;Jet OLEDBSmiley Very Happyatabase 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 OLEDBSmiley Very Happyon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDBSmiley FrustratedFP=False;Jet OLEDBSmiley Frustratedupport 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

1 Solution

Accepted Solutions
MVP
MVP

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

PFA

2 Replies
MVP
MVP

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

PFA

joshabbott
Contributor III

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

You are my hero!  Thank you!

Community Browser