turning excel 22x22 array into a greyscale image

[Al Shinn]

Kind folks,
I would like to convert an  excel (etc) 22x22 array into a greyscale
image.  It's been so long since I last used ImageJ that I don't even
know how to start. Any hints?


Looking forward,
Al Shinn

[John Oreopoulos]

Hi Al, try the File->Import->Raw command which is documented here on the ImageJ website:

http://rsbweb.nih.gov/ij/docs/guide/userguide-23.html#toc-Subsection-23.6

John Oreopoulos


On 2011-08-29, at 2:39 PM, Al Shinn wrote:

> Kind folks,
> I would like to convert an  excel (etc) 22x22 array into a greyscale image.  It's been so long since I last used ImageJ that I don't even know how to start. Any hints?
>
>
> Looking forward,
> Al Shinn

[Stephan Saalfeld]

Al Shinn,

export it as space separated numbers into a txt file and do
File->Import->Text Image...

Cheers,
Stephan




On Mon, 2011-08-29 at 11:39 -0700, Al Shinn wrote:
> Kind folks,
> I would like to convert an  excel (etc) 22x22 array into a greyscale
> image.  It's been so long since I last used ImageJ that I don't even
> know how to start. Any hints?
>
>
> Looking forward,
> Al Shinn

[G. Esteban Fernandez]

What I do is save the spreadsheet as a text file and edit the text
file to convert to PGM format (change extension to .pgm), for example:

---------------------------------top of text file
P2
#P2 means this is a grayscale "plain" PGM file in human-readable
format (# designates a comment)

5 5
# width & height; array values below populate an array of this size
rows-first regardles of dimensions below

255
#max pixel value, values greater that this are displayed as the mod with max

# this array produces a 5x5 image with all pixels intensity 1

1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
---------------------end of text file



On Mon, Aug 29, 2011 at 11:39 AM, Al Shinn <[hidden email]> wrote:
> Kind folks,
> I would like to convert an  excel (etc) 22x22 array into a greyscale image.
>  It's been so long since I last used ImageJ that I don't even know how to
> start. Any hints?
>
>
> Looking forward,
> Al Shinn
>

[Antoinette]

Whether we want to turn and convert excel document 22x22 array into a greyscale image or any other image color mode, we need to use an excel converting application that owns the abilities to convert excel to image file formats.