• 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
Copying unicode from Excel and pasting to text file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Copying unicode from Excel and pasting to text file


  • Subject: Copying unicode from Excel and pasting to text file
  • From: Jason Adams <email@hidden>
  • Date: Tue, 18 Jan 2011 13:51:36 -0500

I have an Excel spreadsheet which contains Korean characters in who
knows what encoding -- I'm assuming it's UTF-8 since I can copy and
paste it into vim or textedit or whatever just fine.  I can then
insert those characters into a database I know is UTF-8 and that works
just fine.

However, when I run the following script that presumably does the same
thing, I get all the Korean characters replaced by the letter "a".  Is
there a way to force an encoding when copying or pasting with
AppleScript?  Am I missing something else?

Thanks in advance

tell application "Microsoft Excel"
	activate
	open (choose file)
	activate object sheet "Sheet1"
	copy range range "A1:G1000" of active sheet
end tell

tell application "TextEdit"
	activate
	open (choose file)
	tell application "System Events"
		keystroke (the clipboard)
	end tell
end tell

--
Jason
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Prev by Date: Re: varibles in handler
  • Next by Date: Re: varibles in handler
  • Previous by thread: Re: varibles in handler
  • Next by thread: AppleScripting InDesign Yahoo! Group
  • Index(es):
    • Date
    • Thread