BMP to XYscatter chart: How can I put a hexadecimal dump in a textfile/spreadsheet?

[rhmd]

I am working on a macro to convert small bitmap files into Excel
xy-scatter charts, by using the markers as if they were pixels, for a
lithograph type effect. In order to do this I need to put the
hexadecimal code into cells in the spreadsheet. There is one very
basic programming task I don't know how to do: get a hexadecimal dump
into a text file. (From there, it's not too hard to format the
"hexadecimal dump" text into short lines with a word wrap in WordPad,
and then copy it into cells on the Excel spreadsheet, and then "parse"
it to do what I need it to do.)

There's probably a very simple DOS command or freeware utility that
puts a hexadecimal dump of a binary file into a text file or the
clipboard: does anyone know what it might be?

Thanks very much.

 

[John Walkenbach]

Try Hex Editor from HHD Software (free):

http://www.hhdsoftware.com/hexeditor.html

You can view a file in hex, and then copy/paste the hex digits to a text
file.

I'll be interested to hear if you have any success treating data markers as
pixels.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

 

[Andy Pope]

Hi rhmd,

You might find the BMP routines in the examples useful.

(http://andypope.info/fun/bmpconvert.htm)

I am working on a macro to convert small bitmap files into Excel
xy-scatter charts, by using the markers as if they were pixels, for a
lithograph type effect. In order to do this I need to put the
hexadecimal code into cells in the spreadsheet. There is one very
basic programming task I don't know how to do: get a hexadecimal dump
into a text file. (From there, it's not too hard to format the
"hexadecimal dump" text into short lines with a word wrap in WordPad,
and then copy it into cells on the Excel spreadsheet, and then "parse"
it to do what I need it to do.)

There's probably a very simple DOS command or freeware utility that
puts a hexadecimal dump of a binary file into a text file or the
clipboard: does anyone know what it might be?

Thanks very much.

--

Cheers
Andy

http://www.andypope.info