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.
Topic: Excel Hash-256 (Read 151 times)
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.
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.
Jump to: