Re: Perl or Applescript w/ Excel
Re: Perl or Applescript w/ Excel
- Subject: Re: Perl or Applescript w/ Excel
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 14 Aug 2002 12:52:37 -0700
On 8/14/02 11:44 AM, "Pia Zador" <email@hidden> wrote:
>
I am about to write a script that takes a bunch of tab-deliminated text
>
files, extracts certain numeric data, performs simple arithmetic on the
>
extracted data, and outputs the new data to a workbook in Excel.
>
>
Does anyone have suggestions on whether to use Perl scripts or simply
>
Applescript? Is one easier to use when dealing with tab deliminated data
>
and/or Excel workbooks?
>
Excel has an really thorough AppleScript implementation, that's very fast
when you take full advantage of it. Its just completely undocumented, aside
from its large but very terse dictionary, so there's a lot of trial and
error involved in figuring out what to do. Simply opening a tab-delimited
text file in Excel is very easy, but there's lots. lots more you can do once
you're inside. I can't see how perl would speak to the application at all.
--
Paul Berkowitz
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.