12 Replies Latest reply: Feb 12, 2016 9:41 AM by Julisy Amador RSS

    Issue with deploying code reading multitab excel

    Michael Jordan

      Hi all,

       

      I have few excel files with multiple tabs. The tab names are not consistent and can change over time but the format of the tabs is same.

      Thus when reading multiple tabs I am using the below code

      For Each vFile in FileList('$(vFolder_FileFormat)')

       

           ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)];

           Sheets:

           SQLTABLES;

           DISCONNECT;

       

           For i = 0 To NoOfRows('Sheets')-1

              Let zSheet = Peek('TABLE_NAME', i, 'Sheets');

       

        Data:

        LOAD

        *

        FROM [$(vFile)]

        (biff, embedded labels, table is $(zSheet));

       

           Next

        

        Drop Table Sheets;

      Next

       

      Now since our Qlikview server doesn't have a Excel installed the line "ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)];" is giving me error.

      Is there any way to just install Excel drivers and make the code work without installing microsoft office?

      Kindly suggest. Many Thanks in advance.

       

      Regards

      Amar