insert in indesign an xls... analyse it and edit in indesign

Scripting Forums AppleScript | Mac OS X
,
#1

hi all,

some questions :slight_smile: :

i need to import the xls file. In one of the colums there are reference numbers.

for example 3.098.987.988 ¶ Description ¶ aditional info (¶ is the symbol i now used to indicate next colum)

and for some references there are pictures… some don’t have any… some do… the pictures are named: referencenumber (without dots). jpg/eps/psd/ai/…

so how can i read the content of the column row by row?
can i compare it with filenames in finder?
and how do i edit the inserted table in indesign that indesign places the image in between the rows?

this is my insert xls code:


tell application "Adobe InDesign CS3"
	tell excel import preferences
		set alignment style to spreadsheet
		set decimal places to 4
		set table formatting to excel unformatted table
	end tell
end tell

set myFile to (choose file with prompt "Choose your text file") as text

tell application "Adobe InDesign CS3"
	activate
	set myDocument to make document
	set mySpread to active spread of active window
	tell mySpread to set myFrame to make rectangle with properties {geometric bounds:{"10", "10", "287", "200"}}
	tell myFrame to place myFile
end tell