1 Reply Latest reply: Apr 28, 2017 8:27 AM by Peter Rieper RSS

    Section Access Through Excel Files

    Ahmad Hamdani

      Hi All,

       

      I have some questions here, I create section access in qvw files using excel and I try to load in script, and I try to load table with same file.

      And the problem is, why data always showing all data table and not same with section access login?

      I want data show same with section access login, is there any settings need to set?

       

      Thank You.

       

      section access;

      LOAD ACCESS,

                USERID,

                PASSWORD

      FROM

      [..\Sheet_access.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      section application;

      [Sheet Level]:

      LOAD USERID,

                Tab1,

                Tab2,

                Tab3,

                Tab4,

                Tab5

      FROM

      [..\Sheet_access.xlsx]

      (ooxml, embedded labels, table is Sheet2);

       

       

      Capture.JPG