Skip to main content
Participant
October 25, 2018
Question

Renaming artboards from an Excel file

  • October 25, 2018
  • 3 replies
  • 831 views

Is it possible to rename dartboards in Illustrator using data from an Excel file? Might this require an Illustrator script as well as a JS to reach put to the Excel file?

This topic has been closed for replies.

3 replies

CarlosCanto
Community Expert
Community Expert
October 25, 2018

how many Artboards do you have? if you only have a few, use this script and type your names directly in the array. Also you might be able to convert your excel names into a string using a formula and paste directly in the script...but to answer your question, yes, it is possible to read names from a file, a CSV file.

// rename Artboards

// CarlosCanto

// https://forums.adobe.com/thread/2489726

function main() {

    renameArtboards (['CV', 'UC', 'GE']);

}

main();

// renames artboards to provided array of names

function renameArtboards (names) {

    var idoc = app.activeDocument;

 

    for (i=0; i<names.length; i++) {

        ab = idoc.artboards;

        ab.name = names;

    }

}

Participant
October 25, 2018

Carlos,

There are about 15 artboards per Illustrator file, and hundreds of Illustrator design files per year. I am not a developer or a coder but do see that having script to convert the Excel data to artboard names would be a giant leap forward. How can I proceed, is it possible to hire someone to write the script? Thank you most kindly for your response, greatly appreciated.

CarlosCanto
Community Expert
Community Expert
October 25, 2018

Hi vision, send me a PM with your details and we'll work something out.

Thanks Carlos

Disposition_Dev
Legend
October 25, 2018

you could do this with JS inside illustrator, however it's best to save your Excel file as a CSV first since excel workbook/worksheet documents are full of proprietary microsoft encrypted gibberish.

Srishti_Bali
Legend
October 25, 2018

Hi Mark,

I think this would be best answered on our scripting forum, hence moving it to Illustrator Scripting​ forum.

Regards,

Srishti

Participant
October 25, 2018

Thank you!