Re: Excel import

Article View: adobe.scripting.indesign

Article #17693

Back to adobe.scripting.indesign Previous Next

#17693

From: Shane Stanley
Date: Sun, 18 May 2003 11:03

19 lines
1499 bytes

in article 1de92b54.-1@WebX.la2eafNXanI, williamhaussmann wrote:

> I'm trying to import a part of an excel sheet into a block without having to
> specify the sheet name and the range manually. Does anyone know the correct
> syntax for specifying the sheet and the range in the 'place' command?

You need to set the "excel import preferences" before you do the place:

tell application "InDesign 2.0.2"
 tell excel import preferences
  set sheet name to "Blah"
  ...
 end tell
 place...
end tell

-- 
Shane Stanley,  sstanley@myriad-com.com.au

Technical Details

Message-ID: <BAEDA589.5A5F4%sstanley@myriad-com.com.au>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!WebX

References: <1de92b54.-1@WebX.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,579464c99d96b2e4
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2003-05-18 04:08:10 PST
From: Shane Stanley <sstanley@myriad-com.com.au>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.scripting.indesign
Subject: Re: Excel import
Message-ID: <BAEDA589.5A5F4%sstanley@myriad-com.com.au>
Date: Sun, 18 May 2003 04:03:05 -0700
References: <1de92b54.-1@WebX.la2eafNXanI>
Lines: 22
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.6
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message