How to deal with forgotten Excel worksheet password

The first thing to note is that only Excel2007 and above versions support this encryption removal operation.

First change the suffix xlsx of the table file to the two compressed files of RAR or ZIP.

After the file becomes a compressed package, open it, unzip it, and find the workbook in the xl/worksheets directory inside.

Open whichever workbook has encryption and use Notepad to open it. Find the line of code containing sheetProtection password, delete the content in brackets and save it.

Finally repackage the folder, change the format of the compressed package back to xlsx format and open it. Finally, you will find that the password of the form has been eliminated and you can edit it easily. La.

The above is the detailed content of How to deal with forgotten Excel worksheet password. For more information, please follow other related articles on the PHP Chinese website!