Action to change stroke color and save, based on an excel file

[philip thomasp67806257]

Hi there, I have a drawn a metal part on Illustrator, that I need to save in 190 different colors. Each color has a name (i.e. RAL 1000, RAL 1001 etc...) I have all the names and the HEX colors saved in an Excel file. (Column one is the name, column 2 is the Hex)

So basically, my action should do the following.

1. Change stroke color of my drawn item to the value of the hex color

2. Save and name according to the color name (RAL 1000...)

Repeat 190 times according to the 190 lines of my excel spreadsheet.

Can this be done, and if so, any advice on how to implement this?

[Silly-V]

Hey, check out my three articles on this:

Illustrator Variable Data Advanced Techniques: Recoloring art from data column. | LinkedIn

Variable Recoloring workflow: The Preview Action | LinkedIn

Recolor Workflow: Using a Color Map Spreadsheet | LinkedIn

[philip thomasp67806257]

Thanks for the answer, I fear that adapting this (even though my needs are simpler than what you've achieved) is beyond my skill set. Would it be easier if I already had the color swatch. I have found the RAL swatch online.

So now, all I'd need to do is export the group in as many color variations as there are in the swatch...

[Silly-V]

What is the RAL swatch?

Also, fear not, the last article shows you how to make this whole thing easier.

[philip thomasp67806257]

RAL is a colour standard used in powder coating and varnishing (doors and windows mostly...). The company offers a digital kit which includes all their colours: RAL Farben | RAL DIGITAL 5.0 Lizenz für Vollversion

I'll take a closer look at the last article , thanks a lot !

[Silly-V]

Why don't you PM me your email and I can send you a sample file-set which has your basic setup for you to study and replicate?

[philip thomasp67806257]

I've sent you a PM! Many, many thanks for your help!

[renél80416020]

Bonjour,

J'ai réalisé le script qui fait le travail demandé,

//----------------------

So basically, my action should do the following.

1. Change stroke color of my drawn item to the value of the hex color

2. Save and name according to the color name (RAL 1000...)

Repeat 190 times according to the 190 lines of my excel spreadsheet.

//--------------------

J'aimerais recevoir par mail un exemple de fichier excel et ai pour test réel.

Si cela est possible.

de LR

[philip thomasp67806257]

Je vous ai envoyé un mp.