Excel的工作表密码保护如何工作

本文介绍了Excel的工作表密码保护如何工作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 这段代码已经在网络上浮动了好几年 - 显然可以提供密码来解密你不知道密码的excel电子表格。This code has been floating around the net for quite a few years - it's apparently able to provide a password for decrypting an excel spreadsheet that you don't know the password to. http://www.theofficeexperts.com/VBASamples/Excel02.htm我对这是如何工作感兴趣，但我似乎无法做到这一点。我假设它是以一定的价值加密的，可以通过多种方式获得（网上的几个地方说它会给你原始密码或另一个可以工作的），像公钥一样 - 您可以拥有100个公钥，所有这些都可以使用一个私人密钥。I'm interested in how this works but I don't seem to be able to work it out. I'm assuming it's encrypted under a certain value that can be gotten to in a number of ways (a few places on the net say it'll give you the original password or another one that will work) sort of like a public key - you can have 100 public keys that all work with a single private one.对我来说，它似乎是创建整数变量，并填写一个特定的数字，数字进入相关字符。这些总是不一样吗？如果是这样，Excel保护是否有主密码？To me it seems like it's creating integer variables and filling them with a specific number, before turning that number into the relevant characters. Wouldn't these always be the same? If so, is there "master password" for Excel protection?感谢所有！编辑：在我发布的示例代码中注意到了对于n = 32到126 。使用ASCII表进行交叉引用，这似乎是从空格到波浪号的所有字符。这是一种类型的字典攻击我不明白由于语法？ I've noticed the For n = 32 To 126 in the example code I posted. Cross referencing with an ASCII table that seems to be all characters from space through to tilde. Is this some sort of dictionary attack I'm not understanding due to syntax?推荐答案这是一个小世界，作为代码表示我在10年前的另一个论坛上发布了该代码，在其他地方看到过该代码 - 我认为 John Walkenbach的旧网站It is a small world, as the code indicates I posted that code at another forum around 10 years ago having seen it somewhere else - I think on John Walkenbach's old web site 请注意，此代码保护仅适用于工作表保护 - 不适用于Excel的文件打开或VBA密码。 这个写作的一个例子是这里（下面的截图） googling excel sheet protectiontestandzzyw提供其他参考，如来自Tom UrtisOne example of this write-up in full is here (screenshot below)googling excel sheet protection "test" and "zzyw" gives other references such as this from Tom Urtis 这篇关于Excel的工作表密码保护如何工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！