Thanks David. Wow, I’m surprised my Google searching doesn’t reveal anyone else having encountered this problem.
Well, I’m working on a fix in case it helps anyone. Here’s an Applescript that dumps contents of all text frames of the active Excel doc into page 1 of the active ID file (paste into Script Editor and hit Enter key to see proper formatting — and change the en dashes in comments into 2 hyphens; this site auto-‘cleaned’ them when I pasted):
set textbox_text to {“”}
tell application “Microsoft Excel”
tell active workbook
repeat with y from 0 to count of sheets
tell sheet y
–get properties of text frame 1
repeat with x from (count of textboxes) to 1 by -1
set textbox_text to textbox_text & caption of textbox x & return & return
end repeat
end tell
end repeat
end tell
end tell
textbox_text
tell application “Adobe InDesign CS6”
–Find change needed to add proper paragraph ends where before were forced line breaks
set find grep preferences to nothing
set change grep preferences to nothing
set find text preferences to nothing
set change text preferences to nothing
set find what of find text preferences to “^n” –forced line break from Excel text box
set change to of change text preferences to “^p” –end of paragraph
activate
tell active document
tell page 1
make new text frame with properties {geometric bounds:{2, 1.8, 27, 19.8}, contents:textbox_text as string}
end tell
end tell
set myFoundItems to change text
end tell
.
