2 Replies Latest reply: Nov 28, 2014 3:07 PM by Josh Abbott RSS

    Excel - Read in list of Sheet Names from Script

    Josh Abbott

      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