11 Replies Latest reply: May 18, 2009 2:18 AM by Tomoptics RSS

    How to

    Tomoptics

      I wish to select a small area in an image displayed on the Photoshop screen and transfer the pixel intensity levels to an Excel spread sheet?

        • 1. Re: How to
          D Fosse-QDEaQ1 Community Member

          Huh? The info panel will give you the RGB numbers if that's what you want. (But that is relative to the color space you're in!)

           

          Set the sample size in the eyedropper options. There's also a Blur > Average filter to use on a selection.

          • 2. Re: How to
            sfjedi Community Member

            Do you know how to program? Because if you need to do this more than once you're really going to need a custom tool for something like this.

            • 3. Re: How to
              Tomoptics Community Member

              Hi Jed

               

              Do you know of any custom tool that is available to do this?

               

              Regards

               

              Tom

              • 4. Re: How to
                sfjedi Community Member

                No, that's what I'm saying, If I were you, I would create a folder to place all your screenshots in, but they would have to be cropped PERFECTLY!

                 

                Then, I would probably write the program in C# because it's really easy that way. Email me at jed dot hunsaker at gmail dot com if you want to talk more specifics and you need help.

                • 5. Re: How to
                  Tomoptics Community Member

                  Thanks Jed. I am afraid I am not into writing software and was hoping some existed that I could use easily. I shall have to get my daughters help on this!!

                   

                  Tom

                  • 6. Re: How to
                    TLL... Community Member

                    The 'Extended' version of CS3 (or CS4) can do this. A way to go would be to select the part of the image you want to measure, create a new image from it and then export the histogram infomation from it as a .csv using the 'Analysis' tools. I've been incorporating something like what you want to to do in my OTJ work to spot check intensity values in hundreds of aerial image tiles.

                    • 7. Re: How to
                      Reynolds (Mark) Community Member

                      I wish to select a small area in an image displayed on the Photoshop screen and transfer the pixel intensity levels to an Excel spread sheet?

                      would help if I knew what on earth that meant- I dont think anyone does

                      • 8. Re: How to
                        TLL... Community Member

                        I think the OP wants to measure and record where the pixels in an image area fall into the 256 brightness levels (from white to black) of a given channel (R,G,B or grayscale).

                         

                        The extended version of PS lets you do this by exporting the histogram brightness values of said image into a spreadsheet. That way you can compare one set of brightness data to another, find averages, what part of what images might fall out of a given set of constraints (clipping highlights or shadows) and all that other neat spreadsheet stuff.

                         

                        How's that?

                         

                         

                        • 9. Re: How to
                          Tomoptics Community Member

                          Sounds good! I shall have to find a friend with the latest version of Photoshop to try it out.  Thanks

                          • 10. Re: How to
                            Paulo Skylar Community Member

                            Two points of clarification on the on-target response from TLL...

                             

                            The data exported from Photoshop is pixel anonymized, that is, while it will tell you how many pixels have a certain value it will not tell you which pixels have which values.  If you need that sort of array data, other software has to be used.

                             

                            It is not just the latest version of Photoshop one needs to do the ananlysis TLL... mentioned, but a particular version, the Extended version, of either Photoshop CS3 or CS4.

                             

                            Paulo

                            • 11. Re: How to
                              Tomoptics Community Member

                              Hi Paulo

                               

                              Thank you very much for that vital information. I do in fact need to know which pixel has which value.

                               

                              Tom