In a single application, Is that possible to show 1st Sheet to few users and 2nd Sheet to other users?

[#1]

Hi All,

In a single application, Is that possible to show 1st Sheet to few users and 2nd Sheet to other users?

So For user A 2nd Sheet should be hidden and for user B 1st Sheet should be hidden, If it is possible where to and how to do this? My users are coming from AD users.

[jagan]

Hi,

Check this links

Sheet level access

Sheet Level Access

Hope it helps you in implementing this.

Regards,

Jagan.

[#3]

Hi Jagan,

I have gone through your post but still I did not have clear idea that what you are trying to do.

I tried  log in with User B and C but did not allow to log in. Only A and D are getting allowed to log in.

My question was B should see only Sheet1 and C should see only Sheet2 but this is not happening.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$ #,##0.00;$-#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    Admin, A

    User, B

    User, C

    USer, D

];

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

     Sheet1,

     Sheet2

FROM

sheetlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

[ali_hijazi]

Yes you can hide sheets from specific users

go to sheet properties ->General and put your condition to show or hide the sheet as in the following screen shot

you have to have a table that has the user, the sheetId, and the flag that says 1 or 0 depending on whether the user has the right to see the sheet or not

then in the conditional space you can write something like = if flag is zero where sheet is sheetId then 0 else 1

[PrashantSangle]

Hi,

Try simple session access

try below code

Section Access;

LOAD * INLINE [

    ACCESS, USERID,Sheet ID

    Admin, A

    User, B,Sheet1

    User, C,Sheet1

    USer, D,Sheet2

];

Section Application;

or do as suggessted by Ali

in conditional write

for sheet1

if(wildmatch(OsUSer(),'B','C'),1,0)

change your condition as per requirement.

Regards

[nagarjuna_kotha]

Hi,

Go through the below link.

Sheets Security with Section Access File

Regards,

Nagarjuna