Re: Perl or Applescript w/ Excel
Re: Perl or Applescript w/ Excel
At 11:44 am -0700 14/8/02, Pia Zador 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?
The only reason for using Apple Events would be if you wanted the
worksheet to be made fancy in some way with pretty colours or some
such. With perl you would be able to create the file in a fraction
of a second, whereas no matter how fast your machine, the sheer
quantity of apple events to Excel, if you were to use no other
method, would make the process far slower and to no good purpose.
Not only that, but what you would be able to do with a few short
lines of code in perl would take a page or two of verbose stuff in
AppleScript, let alone the problems of doing the arithmetic and
formatting the result, which in perl is just a simple printf.
JD
_______________________________________________
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.