6 Replies Latest reply: Mar 16, 2017 1:17 PM by Tobias Scholl RSS

    Retrieve data from an Excel-Sheet located on a SharePoint Server.

    Tobias Scholl

      Dear all,


      I need to retrieve data from an Excel-Sheet located on a SharePoint Server.

      This works perfectly in Qlikview:

      LOAD A,

           B,

           C

      FROM

      \\mySharePoint\Shared%20Documents\test.xlsx

      (ooxml, no labels, table is Output_short);

       

      The same code however fails in QlikSense:

      This statement only works with lib:// paths in this script mode

       

      Creating a new Folder Data Connection as suggested in this post does also not help but results in the error: Invalid Path.


      Any help would be highly appreciated

       

      Best,
      Tobias