Update Cell-Level Security in Groovy
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
Tagged:
5