MD5哈希函数在excel中? [英] MD5 Hash function in excel?
问题描述
我想将我的文档中的一些excel单元格从序列号转换为该序列号的MD5哈希值。有没有一个预编译的excel中的公式,或者是我唯一的选择VBA。如果VBA,我该怎么做?
I would like to convert a number of excel cells in my document from a serial number to the MD5 hash of that serial number. Is there a precompiled formula in excel that does that, or is my only option to do VBA. If VBA, how would I do it?
推荐答案
问题 Excel VBA的密码哈希函数现在已经被破坏了。以下是该问题的接受答案的更新版本:
Some links in the question Password hash function for Excel VBA are now broken. Here is an updated version of the accepted answer on that question :
您将在这里找到一个VB
和VBScript的实现:
http://web.archive.org/web/20080526064101/http://www.frez.co.uk/freecode.htm#md5
我相信这将是非常容易的移植到excel。
I believe it would be quite easy to port to excel.
然而有人已经这样做了。不幸的是,解决方案是
专家交换,不允许
直接链接。所以我们必须通过Google去
。 点击这里执行
a Google搜索,然后单击
的第一个结果。向下滚动很多以查看
接受的解决方案。
However someone has already done that. Unfortunately the solution is at experts-exchange which doesn't allow straight links. So we have to go through Google. Click here to perform a Google search and then click the first result. Scroll down a lot to see the accepted solution.
资料来源: Excel VBA的密码哈希函数
这篇关于MD5哈希函数在excel中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!