JPG swatches of Pantone TPX

Hi all, basically what I need is all Pantone TPX colors as separate JPG's so that on our internal software when someone types in a Pantone # the corresponding color populates from the JPG (which should preferably be named the same as the Pantone #). We are currently using another site that does the exact same thing so I know its out there, but I can't figure out where.
Its an Intranet site that will have a box for them to type the Pantone # in, an next to it should be a JPG of the actual color swatch.
Another solution that would be acceptable is an Excel sheet with all Pantone #'s in one column, & the corresponding Hex # for the closest color in another. This way I can import it into SQL & show the colors that way.

Yes, I know that it will not be exact because of the differences between the screen & print, but they want it anyway.

Thanks in advance.
Jon
LVL 3
Jon DeVitoAsked:
Who is Participating?
 
AngryBinaryCommented:
Here is a link to a Pantone-to-Hex color chart. You should be able to dump this into an Excel file or database.

As far as the JPG... it might be easier to dynamically color an HTML element with the hex value (i.e., <div style="background-color:#FF0011; height:20px; width:60px;"></div>) by writing the style into the element using either JavaScript or whatever your server scripting language is (PHP, ASP.NET, etc).

If you have to have JPGs, you could create a custom handler (ashx, assuming you're using ASP.NET) that takes a hex value as a parameter and outputs a small JPG image on the fly, or pre-generate all the JPGs using a small .NET program. If you go either one of these routes, I could provide a code snippet.
0
 
Jon DeVitoAuthor Commented:
Thanks so much, I totally agree the better way is dynamic colors. The link didn't come through  though, can you paste it again? Thanks!

Jon
0
 
AngryBinaryCommented:
Whoops. I would have had to actually paste it a first time for that to work.

http://www.edigita.com/pantone.php
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
AngryBinaryCommented:
Actually, that data required a little bit of massaging in order to get into a spreadsheet. Very easy with an advanced text editor tho, so I went ahead and dumped it to a CSV for you. Pantone.csv
0
 
AngryBinaryCommented:
... aaaaaaand here it is after fixing rows 124 and 237:  Pantone.csv
0
 
Jon DeVitoAuthor Commented:
Lol, no prob. Thanks for the link but these look like the regular Pantones, not the TPX colors. Thats the specific library that they need to load. I wouldn't even mind buying them if it was cheap enough & I could get it into Excel somehow.
0
 
Jon DeVitoAuthor Commented:
Thanks so much for converting it, I just saw that after I posted.
0
 
Jon DeVitoAuthor Commented:
I can't find any TPX color charts online & I don't know if the download from Pantone for $50 will give it to me in a format that I can export to Excel.
0
 
Jon DeVitoAuthor Commented:
I was able to get into the other softwares database & export the chart to excel. You get the points for pointing me in the better direction of using the hex as a background. Very much appreciated!

Thanks.
Jon
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.