Locking Cells or Columns in Excel

Hi Willem, first of all you need to use the createExcelWorkbook instead of createOutputObject to enable additional methods and classes. Maybe the example below will help...

var workbook = Context.createExcelWorkbook("ProtectedReport.xlsx"); 
var sheet = workbook.createSheet("Data");

// 1. Create the cell style for cells that should remain editable
// The XlsCellStyle class allows setting the 'Locked' property to false
var unlockedStyle = workbook.createCellStyle(null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
unlockedStyle.setLocked(false); 

// 2. Populate the spreadsheet (Example with 100 rows)
for (var i = 0; i < 100; i++) {
    var row = sheet.createRow(i); 
    
    // Iterate through columns A (index 0) to T (index 19)
    for (var j = 0; j <= 19; j++) { 
        var cell = row.createCell(j); 
        cell.setCellValue("Data " + i + "-" + j); 
        
        // Columns Q (16), R (17), S (18), and T (19) are specifically unlocked
        if (j >= 16 && j <= 19) {
            cell.setCellStyle(unlockedStyle); 
        }
        // Columns A through P (indices 0 to 15) remain locked by default in Excel
    }
}

// 3. Activate spreadsheet protection
// Protection must be enabled on the sheet for the 'Locked' cell property to take effect
sheet.setProtect(true); 

// Optional: Define a password for the protection
// sheet.setPasswordProtect("yourPassword"); 

workbook.write(); 

@Pablo Gonzalez,

Thank you, it works.🙏