加上suspendPaint和resumePaint即可,例如下面代码
- var workbook = designerAll.getWorkbook();
- workbook.suspendPaint();
- for(let i = 0; i<workbook.getSheetCount();i++){
- let sheet = workbook.getSheet(i)
- sheet.options.isProtected = true;
- //行循环
- let rowCount = sheet.getRowCount();
- for(let row=0; row<rowCount;row++){ //行循环
- //列循环
- let colCount = sheet.getColumnCount()
- for(let col=0; col<colCount;col++){ //////列循环
- let cell = sheet.getCell(row, col);
- cell.locked(true);
- }
- }
- }
- workbook.resumePaint();
复制代码
|