Section Access Through Excel Files

hamdaniahmad — Wed, 22 Mar 2017 08:55:29 GMT

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);

Re: Section Access Through Excel Files

prieper — Fri, 28 Apr 2017 12:27:01 GMT

In the Document-Settings you need to tickmark under "Opening" the fields "Initial Data Reduction...." and "Strict Exclusion".

When running the script you can see all data (ADMIN-property).

HTH Peter