Leigh J. Halliwell wrote: > Raul, X was a 4-by-4 range of numbers. But when I restricted it to one > cell, js.Do did the arithmetic. Can you give me an example of passing a > numeric range from Excel to J?
AFAIK, only strings are passed in J's oleautomation, Excel or J may convert string to numeric automatically, should it fail, you have to do conversion yourself. pls refer to clipunfmt and clipfmt in system\examples\ole\excel\xlutil To coerce it to numeric need something like, X=. >0&".&.> X or X=. >0&".&.> clipunfmt X I'm not sure because I seldom use oleautomation. -- regards, bill ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
