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:
2