Jump to content

[Release] Byte count in Excel


Recommended Posts

I am particularly rusty on VBA, however I happened (while attempting to write *another* thing) to find a piece of nice VBA code for opening files, here:


which I of course right away stole :w00t::ph34r: for my project.


As often happens, in order to understand how the snippet worked I did some tests completely unrelated to the original goal, and by pure chance I (half-@§§edly as usual) put together something that may be of actual use.


Find attached a simple spreadsheet that counts bytes in a file and draws a quick graph of their frequency  by value :yes:.


Such graphs are normally part of some disk/file/hex editors, among them I will cite X-Ways (commercial):


and (freeware) HXD:


Graphical representation of the byte/character distribution



and sometimes are useful to analyze "unknown" files.


Only very BRIEFLY tested on "smallish" files, YMMV.


Have fun :).




Link to comment
Share on other sites

  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...