🚀 go-pugleaf

Wolfgang

You are right, but that was not my intention with this script, instead it is
aimed at cases where you have a fairly small Excel sheet, lets say a report
card, customer card, etc. and need to insert values from these into your
document.

The reason I chose this approach was that character styles is very familiar
to most users and hence setting up the document template so to speak would
be very easy and require no scripting knowledge whatsoever.

What approach you should to take depends very much on the nature of your
documents. The problem one faces is to have the target defined so it can be
referred to in a predictable way no matter if you add, remove or rearrange
page items.

There is one approach that would allow you to define source document, sheet,
cell, as well as the target with more flexibility, and that is to tag the
target text/object with an XML tag and let the attributes define all these
things, something like this:

<myXMLtag Cell="A2" Sheet="Sheet 1" SourceDoc="Macintosh
HD:Users:richardr:desktop:Excelfile.xls">

That way you could get away with just one XML-tag and just change the
attributes. There are however problems with that too, for one, you can not
tag things in an InDesign table

Perhaps someone else has a better way, but it seems to me that what you
would need is a plugin for database publishing