@
bfhh126 vba 那个没注意, 这个是改文件名为 zip 后手动复制的, 你试下.
https://community.spiceworks.com/fix/remove-excel-password?source=canonical#zip-related1.Create backup of password-protected excel file.
2.Change the file extension to .zip from .xlsx.
3.Now extract the whole content of zip file.
4.Search for xml format of targeted sheet. You will find it in ‘ xl -> worksheets ’ directory.
5.Open the xml file of targeted sheet in xml editor.
6.Now search for ‘ sheetProtection ’ word in that xml file and remove it.
7.Save this edited xml file and replace it with old xml file in zip files.
8.Now change the extension from .zip to .xlsx.