const sheet = spread.getActiveSheet()
const colNum = sheet.getColumnCount()
const rowNum = sheet.getRowCount()
// sheet.getRange(0, 0, rowNum, colNum).formatter('0;0;')
for (let m = 0; m < rowNum; m++) {
for (let n = 0; n < colNum; n++) {
sheet.getCell(m, n).formatter('0;0;')
}
}现在这个方法,页面会有卡顿,好几秒动不了页面
|
|