|
Title: Excel Hash-256 Post by: Cazemiro on March 06, 2021, 06:50:58 PM I was looking for a Excel Hash-256, and found this post:
https://stackoverflow.com/questions/46509572/excel-formula-based-function-for-sha256-sha512-hashing-without-vba-or-macros It was almost done, but the imput is a String, and I needed a binary hash in Hex bytes. I changed the original file for 32 hex binary, it is working good, only for this propouse. If someone want is possible to download on this link: https://docs.google.com/spreadsheets/d/1ERgIVxvsByhlIKJyMj1TH5jDu_BfUL464yvT9s40pH0/edit?usp=sharing The original format (string 55 chars) can be download on: https://drive.google.com/open?id=17FsOyyr9RkwWj0Ug1tbyqJ5sSljGSjjg Thanks a lot to @PGSystemTester, for made the Hash for excel. I couldn't find anything like this, so I decided to share it here. If someone have more excel functions, like this I have interest. Title: Re: Excel Hash-256 Post by: NotATether on March 07, 2021, 04:47:32 AM It's a nice achievement but it's not very practical to use because you need a whole new sheet every time you want to use SHA256.
The reason why cryptographic functions aren't included inside spreadsheet functions is because of their complexity to implement, and also they have to be certified if any serious customer is to use them, not to mention the "why bother" factor since you can already do this with VBA. But this sheet gives a nice, easily viewable layout of SHA256's internal state so it's useful for learning purposes. |