Copy link to clipboard
Copied
I know this must have been answare before.
I'm looking for a script that can take an excel or csv file an put it in an exisisting tabel in indesign.
Scenario
I have a prislist whit tables. I those tables i have, among other things, item number and price column's. What i would like to do is run the script, select the excel/csv file, lookup item number and change the price i the same row in design.
Hope it makes sense
Copy link to clipboard
Copied
HI,
can you confirm the version of InDesign and Operating System you are using.
Have you tried Data Merge?
More details at Merge data to create form letters, envelopes, or mailing labels in Adobe InDesign
Copy link to clipboard
Copied
I'm using indesign CC 13.1 on windows 10.
I haven't tried data merge, because as I understand it, data merge can't handle condition's (if col x = item number then col y = price).
Via this link you can see the final price catalog.
https://www.rc-beton.dk/wp-content/uploads/2015/12/prisliste-oj-2018-web.pdf
Copy link to clipboard
Copied
The December issue (issue 116) of InDesign Magazine has a long, in-depth article on Excel for InDesign Users you may find helpful: https://indesignsecrets.com/
Copy link to clipboard
Copied
Discussion moved to InDesign Scripting​
Copy link to clipboard
Copied
While I just can advocate for EasyCatalog, you can tackle this with a script. But at this point you have two solutions. One is to get your hands dirty and try creating it (people will then assist you) or order this development to an experienced script writer.
Copy link to clipboard
Copied
It is possible to interact from InDesign with Excel by script directly. (Without the extra step of exporting from Excel to CSV/TXT format).
Here I wrote functions (both for PC and MAC) which read the data from Excel. That's the complex part. They work well for me for about three years.
The function for Windows has two versions:
1 — can process only one spreadsheet
2 — can process all spreadsheets in the workbook and also gets spread's name
The rest is relatively easy: a chain of 'find this — change to that operations'. You can find many examples of how to approach this: here on the forum, the 'find change by list' script which comes with InDesign, on my site.
Hope it helps.
—Kas