Skip to main content
johnandersonpixel
Known Participant
December 9, 2016
Question

Clipboard data from photoshop to excel

  • December 9, 2016
  • 2 replies
  • 3251 views

HI,

     Is it possible to copy the active layer group name to clipboard and paste in a excel file to get get the value from the cells and return to user to notifies the product type as an message.

for example: I am having three layer-sets in the active document so now i click the first layer group named CYF022 and i need to copy it from Photoshop and paste it into the excel sheet to know the product information.

so i had an idea to copy the active layers name to clipboard but have no idea to paste that value in the sheet and get value from the next column cell and alerts into Photoshop

Anyone please help me on this !

my excel file will be like:

https://s16.postimg.org/qmpgkikpx/data.jpg

Thanks,

John

This topic has been closed for replies.

2 replies

johnandersonpixel
Known Participant
December 9, 2016

i want to know the product type for image so that i am using the product code as my reference in layersets so using the name in layer group and get the details from stored excel sheet i want to know to product type while working in photoshop so if any other ideas please tell me out...like shell command or

Inspiring
December 9, 2016

If you create a master spreadsheet of all Product Codes and Product Types and save that as a CSV file you can write a Photoshop script that reads the name of the active layer, look up that value in the CSV file and return the Product Type in PS

johnandersonpixel
Known Participant
December 11, 2016

Yeah even tried that but it take long time while reading data from the spreadsheet. Is there any way to do that quick .actually my master files in on the local server

Inspiring
December 9, 2016

Photoshop and Excel won't communicate with each other regarding alerts and PS won't copy/paste into Excel. Maybe if you could explain your objective a bit more we could find a workaround.