Re: Formula of selection:Formula too big for applescript
Re: Formula of selection:Formula too big for applescript
- Subject: Re: Formula of selection:Formula too big for applescript
- From: Yvan KOENIG <email@hidden>
- Date: Thu, 17 Nov 2005 14:32:14 +0100
Le 17 nov. 2005, à 14:08, Bastiaan Boertien a écrit :
Hi List,
I made a script to convert excell into MySQL. The problem is that the
contents of some cells are too big. When I have 1024 characters in a
cell, the script can get the formula of the selected cell. When I have
1025 characters an error wil return with the message 'microsoft excel
cannot "get formula of selection"' or something. Does anyone know how
to solve this problem. I tried to do an character count, so I can get
the text in pieces, but it will return no value
Greetings Bastiaan
It would perhaps be useful to read the specs of the pair
Excel-AppleScript.
For the one I know the best: AppleWorks-AppleScript for instance, a
field of a database may store 1004 characters BUT Using AppleScript to
extract a field's content is limited to 255 chars.
A tip to try: (pseudo code)
tell application "excell"
select a field
copy to clipboard
end tell
get the clipboard's contents
Using this road we are not fooled by the "odd" AS implementation.
Yvan KOENIG
_______________________________________________
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