//保护工作表
worksheet.protect('111',{
objects: true,
scenarios: false,
selectLockedCells: true,
selectUnlockedCells: true,
formatCells: true,
formatColumns: true,
formatRows: true,
insertColumns: false,
insertRows: false,
insertHyperlinks: false,
deleteColumns: false,
deleteRows: false,
sort: false,
autoFilter: false,
pivotTables: false,
}
);
仔细看了插件的源码,加密方式是SHA512方式加密的,这种方式对2007版本的EXCEL不会生效