Re: writing into an excel sheet
Re: writing into an excel sheet
- Subject: Re: writing into an excel sheet
- From: waynemelrose <email@hidden>
- Date: Thu, 25 Nov 2004 18:48:53 +0100
Jasneet,
I'm going to guess that you might be using the same version as me, this works for me.
tell application "Microsoft Excel"
tell front document
tell front Sheet
set Value of Cell 1 of Row i to "This is a Test"
end tell
end tell
end tell
I had a little trouble setting this up when I first started because I actually found the excel dictionary to be a little difficult to understand compared to other apps dictionaries.. Maybe I haven't done enough scripting either....
Wayne Melrose
On Nov 25, 2004, at 6:01 PM, Paul Berkowitz wrote:
On 11/25/04 5:47 AM, "Jasneet Kaur" <email@hidden> wrote:
<x-tad-bigger>How do I write into a Microsoft excel sheet thru my apple script?</x-tad-bigger>
By using Excel's AppleScript dictionary. Have you never done any AppleScripting? Just write to the AppleScript-Users mailing list if you need help with a specific problem in Excel - don't cross-post to the <email@hidden> or<email@hidden> which have nothing to do with application scripting.
If you've never done any scripting at all, you're going to have to read a book on where to start. I recommend Matt Neuburg's "AppleScript: The Definitive Guide" (O'Reilly). If you've done any application scripting before, you'll already know you need to check out the Excel Dictionary. Depending on whether you are scripting Excel 2004 or an earlier version, the Dictionary will be completely different - it was completely re-written in 2004.
So if you know how to script, and tell us which version of Excel you have, and then whether you're starting from a brand new worksheet or want to edit an existing sheet, and an example of what type of date you want to "write" into it, maybe we could help you. Your question is far too vague - please be a lot more specific as to what you'd like to do. And tell us which version of Excel.
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden