Re: Read a cell in Excel 2004
Re: Read a cell in Excel 2004
- Subject: Re: Read a cell in Excel 2004
- From: David Wignall <email@hidden>
- Date: Thu, 11 Nov 2004 19:03:06 +1300
on 11/11/2004 9:22 AM, Paul Berkowitz at email@hidden wrote:
> At first glance, I don't see anything that returns the type of format of the
> cell values. I'm pretty sure that something like that _should_ be available,
> but I don't know where.
number format of range ("A1")
-- "$#,##0.00"
or
-- "[$$-1409]#,##0.00"
if I choose $ NZ for the currency symbol or
-- "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"
if I select the basic Accounting format. Working on the entirely valid
assumption that it is the same as VBA then you can't pick up the 'category'
of the format, as presented in the interface, but you can read/set the
format of a range object; string or nowadays Unicode text. If you want to
know the category then you have to parse the text. This was the advantage of
'text of range.' Shame that it's gone. It's still there in VBA:
Range("A1").Text
--
Dave
_______________________________________________
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