Skip to main content
D
defaultu8v7osnl3292
Participant
July 22, 2021
Question

script reading XLS

  • July 22, 2021
  • 2 replies
  • 677 views

Salutatous

je débute en AI ..  je dois faire un script ...de la meilleure manière .

simple  ... ( d'après moi  .. )

voici  : dans un fichier EXCEL j'ai 2  colonnes ,  20 lignes

en col A , le nom d'un fichier SVG (ex  :   c:\AI\svg_in\file01.svg'

en col B , le titre de ce fichier 'Paris: Tour Eiffel'

je dois produire un document PDF 

* avec les 20 fichiers 

* et le nom de chaque fichier 

.... 

Merci d'avance

 

Hi

Beginner with AI , I need a script 

I think it's easy...

In an EXCEL file , there are 2 columns

Col A : local addres of a SVG file  ( c:\AI\SVG_IN\file001.svg')

Col B : name of that file ( "Paris  : Eiffel Tower")

The script must create a PDF file with

* the  20 files

* the name of each one

 

Thx in advance

 

This topic has been closed for replies.

2 replies

D
defaultu8v7osnl3292Author
Participant
July 23, 2021

To describe my needs :

* a CSV file with  2 columns  (test01.csv)

containing the full name of the SVG files to be imported in AI

and the NAME of each one 

* A PDF file ,( test001.pdf)  representng the final result

m1b
Community Expert
m1bCommunity Expert
Community Expert
July 23, 2021

Thanks, that helps. There's a script that comes with Indesign called ImageCatalog.jsx (look for it in the scripts panel). It will do 90% of what you need. Do you know how to script Indesign? If so, you can modify the ImageCatalog.jsx to do exactly what you ask. Let me know if you need more help.

D
defaultu8v7osnl3292Author
Participant
July 24, 2021
Hi

Thanks for your help
II will try Indesign
If OK , do I still need Illustrator ???
Can I switch from Illustrator to Indesign ??

Regards

Eric
m1b
Community Expert
m1bCommunity Expert
Community Expert
July 22, 2021

Hi, in order to help, people might need some more information. If possible, could you post sample files?

  1. A few sample svg files, showing range of size differences possible
  2. The data file containing data for the files in (1). I suggest .csv rather than Excel, if possible, because Excel files are more difficult to parse.
  3. An example of the output pdf file based on (1) and (2).

I'm pretty sure this will help people understand what you are doing.

You are a beginner with Illustrator, but please let us know if you are familiar with javascript.

 

P.S. 'easy' is relative here. 🙂

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices