• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Set Excel Import Options in InDesign CS6
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Set Excel Import Options in InDesign CS6


  • Subject: Re: Set Excel Import Options in InDesign CS6
  • From: 2551 <email@hidden>
  • Date: Tue, 12 Nov 2013 22:40:47 +0700

The following example comes from InDesignCS5_Scripting Guide. I don’t have a link, but google should find it for you.


tell application "Adobe InDesign CS5” 

tell excel import preferences

--alignment Style property can be: --center align
--left align
--right align

--spreadsheet
set alignment style to spreadsheet
set decimal places to 4
set preserve graphics to false
--Enter the range you want to import as "start cell:end cell". set range name to "A1:B16"
set sheet index to 1
set sheet name to "pathpoints"
set show hidden cells to false
--table formatting property can be:
--excel formatted table
--excel unformatted tabbed text
--excel unformatted table
set table formatting to excel formatted table
set use typographers quotes to true
set view name to “"

end tell 

end tell 




On 12 Nov 2013, at 21:29, John C. Welch <email@hidden> wrote:

On 11/12/13, 8:55 AM, "Bert Groeneveld" <email@hidden> wrote:

When I manually import/place an Excel file in InDesign CS6, I can set several import options (see attached screendump). Can these options also be set (or overruled)  in an applescript?

Thanks in advance for any answer.
Bert.




Here's the best place to look for documentation on Indesign scripting:

http://www.adobe.com/devnet/indesign/documentation.html


--
"Say it with flowers"
                       - FTD

Anybody know where I can get a Triffid?

Al Tucker
Do not post admin requests to the list. They will be ignored. AppleScript-Users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: Archives: http://lists.apple.com/archives/applescript-users This email sent to email@hidden
References: 
 >Re: Set Excel Import Options in InDesign CS6 (From: "John C. Welch" <email@hidden>)

  • Prev by Date: Re: Set Excel Import Options in InDesign CS6
  • Next by Date: Smile not accepting email AGAIN.
  • Previous by thread: Re: Set Excel Import Options in InDesign CS6
  • Next by thread: Smile not accepting email AGAIN.
  • Index(es):
    • Date
    • Thread