2 Replies Latest reply: Nov 16, 2014 3:57 PM by Matthew Chan RSS

    Get the worksheet names in an Excel Workbook

    Matthew Chan

      In Qlik View, I can use ODBC to get a list of worksheet names inside an Excel workbook using this script

       

      ODBC CONNECT32 TO [Excel Files; DBQ=$(vFileName)];
      WorksheetNames:
      SQLtables;
      DISCONNECT;

       

      I try to do the same in Qlik Sense but it does not work, how can I get a list of worksheet names in Qlik Sense?

       

      Thanks,
      Matthew