You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Update Cell-Level Security in Groovy

edited Sep 30, 2025 9:39PM in Planning

Here is some sample code to create CLS in Groovy

// #### RULE HEADER - START
// 
// Author: Jeremie Richard
// Date: Sep 2025
// Purpose:  Generate Cell Level Security (CLS) in Groovy -
//			 Requires 3 steps
//				1) Define Cell-Level Security content
//				2) Generate XLSX in Zip file
//				3) Update Cell-Level using REST API
//
// Modifications: 
// 
//
// #### RULE HEADER - End

// VARIABLE DECLARATION
    boolean OutputxlsxSeparately=false
    String XLSXfilename = 'CellLevelSecDef_Export.xlsx'
    String Zipfilename = 'CellLevelSecDef_Export.zip'

// 1. Define Cell-Level Security content as needed (For Demo Purpose - XLSX Rows stored into multiple lists)
      String S1Name='Rules'
      List<String> S1R1=['Name','Position','Description','Enabled','Valid

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!