I have a spreadsheet representing 2D measurement data. Think of each cell's numeric value as a pixel intensity at (x,y) where x is the cell's column and y is the row. I would like to visualize the data by creating an image that would have at pixel (x,y) the corresponding cell value.
It would be even better if I could create an image with a rule that assigns certain colors to the ranges of cell values. Say, if the value at (x,y) os less than -0.5 the pixel should be red, between -0.5 and 0.5 it should be yellow, and above 0.5 it should be green, that kind of thing.
Thus the 1st question: is it possible to create such an image in Excel? The closest I've got was Conditional Formatting that colors the cells, but I'd like to get an actual image instead of colored cells.
If the above is impossible here's the 2nd question: is there a tool available to do the above from a CSV file? Exporting that Excel table into a CSV and running it through another tool to obtain an image would work just as well for me.