andysuth
06-30-2009, 05:12 AM
I'm trying to perform a mathematical function on a hex file.
I need to read in a 100 x 1 pixel bitmap file into excel and perform a mathematical function on the coulours contained within.
I've done this manually with a HexEditor program but need to repeat the process many times.
I've read .CSV and .TAB files into Excel, and altered text in a text file before using Excel Macros, but I've never read Hexadecimal values into Excel before.
(I'll also need to save HEX values back into the BitMap once I've processed them).
Has anyone done anything like this before?
I've not actually tried altering code yet, but I was going to see if the routines for reading a text file could be modified to read a HEX file.
Is there a resource that could point me in the right direction?
-Andy.
I need to read in a 100 x 1 pixel bitmap file into excel and perform a mathematical function on the coulours contained within.
I've done this manually with a HexEditor program but need to repeat the process many times.
I've read .CSV and .TAB files into Excel, and altered text in a text file before using Excel Macros, but I've never read Hexadecimal values into Excel before.
(I'll also need to save HEX values back into the BitMap once I've processed them).
Has anyone done anything like this before?
I've not actually tried altering code yet, but I was going to see if the routines for reading a text file could be modified to read a HEX file.
Is there a resource that could point me in the right direction?
-Andy.