• 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: Perl or Applescript w/ Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Perl or Applescript w/ Excel


  • Subject: Re: Perl or Applescript w/ Excel
  • From: Steven Kreuzer <email@hidden>
  • Date: Thu, 15 Aug 2002 13:06:08 -0400

If you are using MacPerl on OS 9.x, you can use the MacPerl::DoAppleScript function to act as glue between perl and applescript.

Not to long ago I had a huge file I needed to do some work with in excel, and I found it to be much easier to use perl to do everything I want with the text and then have a sub routine that uses applescripts to communicate with excel and put everything where it is supposed to be.

IMHO, when it comes to manipulating text, perl blows applescript out of the water
(but then again, what do I know)

Steven Kreuzer
On Wednesday, August 14, 2002, at 02:44 PM, 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?

Thank you.

Pia

_______________________________________________
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.
_______________________________________________
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.

  • Follow-Ups:
    • Re: Perl or Applescript
      • From: Doug McNutt <email@hidden>
References: 
 >Perl or Applescript w/ Excel (From: Pia Zador <email@hidden>)

  • Prev by Date: Scripting Acrobat Suite
  • Next by Date: Re: Monitor Settings (multi-monitor/OS9.2.x)
  • Previous by thread: Re: Perl or Applescript w/ Excel
  • Next by thread: Re: Perl or Applescript
  • Index(es):
    • Date
    • Thread