如何打开有密码保护的Excel文件

方法 1

方法 1 的 2:解锁文件

WH.shared.addScrollLoadItem(‘3e40bda15253beaa585aba5e027422f7’)

WH.performance.clearMarks(‘image1_rendered’); WH.performance.mark(‘image1_rendered’);{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/46/Open-a-Password-Protected-Excel-File-Step-1-Version-4.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/46/Open-a-Password-Protected-Excel-File-Step-1-Version-4.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
1
下载密码破解工具。如果需要密码才能打开Excel文件,那么只能使用密码破解程序来强行破解密码,然后才能打开文件。如果密码很复杂,并且文件是Excel 2007或更高版本,那么可能需要几周甚至数月才能破解它。
X
研究来源

几乎所有密码破解工具都需要付费。如果安装了显卡,就能提高破解程序的处理能力,从而更快地破解密码。常用的破解程序包括:
Accent Excel Password Recovery
Rixler Excel Password Recovery Master
Excel Key
WH.performance.mark(‘step1_rendered’);

WH.shared.addScrollLoadItem(’63aa3ba0cee575f0f0d93c6990ab618e’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4d/Open-a-Password-Protected-Excel-File-Step-2-Version-4.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4d/Open-a-Password-Protected-Excel-File-Step-2-Version-4.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
2
在密码破解程序里载入Excel文件。密码破解程序通常能自动检测文件密码,并显示文件加密类型。

WH.shared.addScrollLoadItem(’62e6bb697026859d788d6c48d42de659′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/52/Open-a-Password-Protected-Excel-File-Step-3-Version-4.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/52/Open-a-Password-Protected-Excel-File-Step-3-Version-4.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
3
开始破解密码。载入程序后,可以开始尝试破解密码了。有些程序允许你选择破解类型,你也可以直接使用默认设置。

WH.shared.addScrollLoadItem(’26e1bf6b813935149d81908ccaadab81′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5a/Open-a-Password-Protected-Excel-File-Step-4-Version-4.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5a/Open-a-Password-Protected-Excel-File-Step-4-Version-4.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
4
等待密码恢复程序找回密码。根据密码强度和计算机运行速度,破解进程可能会耗费几分钟到几个月不等。预计的剩余时间会显示在窗口中。

WH.ads.addBodyAd(‘method_ad_1’)
WH.ads.addBodyAd(‘mobilemethod_ad_1’)广告

方法 2

方法 2 的 2:解锁工作表/工作簿

WH.shared.addScrollLoadItem(‘b6885c406b5028e528954ea1e4e005a4’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/18/Open-a-Password-Protected-Excel-File-Step-5-Version-4.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/18/Open-a-Password-Protected-Excel-File-Step-5-Version-4.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
1
在电脑上找到Excel文件。如果Excel文件里的工作表或工作簿被密码保护,那么你可以编辑文件来解除密码。这个方法仅适用于被锁定的工作表和工作簿。你仍需要首先打开Excel文件。这个方法不能用来解锁被密码保护的文件。
这个方法适用于工作簿或工作表结构被锁定,但你又想编辑文件的情况。

WH.shared.addScrollLoadItem(‘c1d5a342a41f4154d20633ff897d445d’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d9/Open-a-Password-Protected-Excel-File-Step-6.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d9/Open-a-Password-Protected-Excel-File-Step-6.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-6.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
2
启用文件扩展名(如果没有启用的话)。你应该能在文件名的后面看到“.xlsx”扩展名。如果看不到任何扩展名,请在资源管理器窗口的“工具”菜单中选择“文件夹选项”,然后在“查看”选项卡里取消勾选“隐藏已知文件类型的扩展名”选框,这样就能启用扩展名。

WH.shared.addScrollLoadItem(‘421ccecf464216473bc2d4e69105a90f’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Open-a-Password-Protected-Excel-File-Step-7.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c2/Open-a-Password-Protected-Excel-File-Step-7.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-7.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
3
将“xlsx”扩展名更改为“zip”。Windows系统会提示你重命名文件可能会导致文件不可用。确认操作。

WH.shared.addScrollLoadItem(‘b82bdfd3bf1032b57d6e7c9f16581993’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/21/Open-a-Password-Protected-Excel-File-Step-8.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/21/Open-a-Password-Protected-Excel-File-Step-8.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-8.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
4
右键点击ZIP文件,选择“全部解压缩”。这会在当前路径中创建一个新的文件夹,新文件夹与Excel文件同名。

WH.shared.addScrollLoadItem(‘f5d982322b25f90e4057bc56ebdea4aa’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Open-a-Password-Protected-Excel-File-Step-9.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Open-a-Password-Protected-Excel-File-Step-9.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-9.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
5
打开“xl”文件夹,然后选择“工作表”文件夹。这样会显示文档中所有的工作表。每个工作表都是独立的文件,如“sheet1.xml”。

WH.shared.addScrollLoadItem(‘1cc217e286fab88b5603bcfe1dbe49ab’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/44/Open-a-Password-Protected-Excel-File-Step-10.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/44/Open-a-Password-Protected-Excel-File-Step-10.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-10.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
6
右键点击锁定的工作表,选择“编辑”。这会在记事本里打开锁定工作表的XML信息。
如果你尝试解锁整个工作表进行编辑,请返回“xl”文件夹,编辑“workbook.xml”文件。剩余的步骤也是相同的。

WH.shared.addScrollLoadItem(‘2bb358c89a49f81105cc08863b65083f’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e3/Open-a-Password-Protected-Excel-File-Step-11.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e3/Open-a-Password-Protected-Excel-File-Step-11.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-11.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
7
按下Ctrl+F快捷键,打开查找窗口,搜索“sheetProtection”。你将能查看用来保护工作表或工作簿的算法信息。
如果你尝试解锁工作簿,可以搜索“workbookProtection”。

WH.shared.addScrollLoadItem(‘378abbe036fb86c672c7973391ef3993’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5c/Open-a-Password-Protected-Excel-File-Step-12.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5c/Open-a-Password-Protected-Excel-File-Step-12.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-12.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
8
选择里的所有所有内容。选择括弧里的所有内容,包括“sheetProtection”字样,然后删除它。保存文件,关闭记事本。

WH.shared.addScrollLoadItem(’86cb28ce9c06b37c792117245d0c26d0′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/38/Open-a-Password-Protected-Excel-File-Step-13.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/38/Open-a-Password-Protected-Excel-File-Step-13.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-13.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
9
复制编辑好的工作簿或工作表文件。选中编辑好的文件,按下Ctrl+C复制它。

WH.shared.addScrollLoadItem(‘077a88d477de33fc29e9f3dd6adef17c’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0a/Open-a-Password-Protected-Excel-File-Step-14.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0a/Open-a-Password-Protected-Excel-File-Step-14.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-14.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
10
打开之前创建的ZIP文件。双击它打开文件。

WH.shared.addScrollLoadItem(’38ed7577646b0b8412aac43c9ef8c688′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/64/Open-a-Password-Protected-Excel-File-Step-15.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/64/Open-a-Password-Protected-Excel-File-Step-15.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-15.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
11
找到同名文件夹,里面有编辑好的工作表或工作簿。打开“xl”文件夹,然后打开“工作表”文件夹。你应该能在这里看到原始工作表文件。如果编辑了工作簿.xml文件,你应该能在“xl”文件夹里找到它。

WH.shared.addScrollLoadItem(‘4879c4888d59461151363c5b75fca9a8’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cc/Open-a-Password-Protected-Excel-File-Step-16.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cc/Open-a-Password-Protected-Excel-File-Step-16.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-16.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
12
粘贴编辑好的文件,覆盖原始文件。按下Ctrl+V粘贴文件,覆盖原始文件。

WH.shared.addScrollLoadItem(‘fc50c9029f93d9331d899676b42a3e2e’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5c/Open-a-Password-Protected-Excel-File-Step-17.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-17.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5c/Open-a-Password-Protected-Excel-File-Step-17.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-17.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
13
关闭ZIP文件,将扩展名重命名为“xlsx”。这会将ZIP 文件更改回Excel文件。

WH.shared.addScrollLoadItem(‘4525c904b41534bd34d3f3215a7f757f’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Open-a-Password-Protected-Excel-File-Step-18.jpg/v4-460px-Open-a-Password-Protected-Excel-File-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Open-a-Password-Protected-Excel-File-Step-18.jpg/v4-728px-Open-a-Password-Protected-Excel-File-Step-18.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
14
打开文件,导入工作簿、工作表。然后,不输入密码你也能编辑工作簿了。[2]
X
研究来源

WH.ads.addBodyAd(‘mobilemethod_ad_2’)广告

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注