My environment is excel.
I fetch some data (like stock prices) from a data base, and import them with
excel.
Then I have to do some mathematical operations with this data and I would
like to do these operations with J, not with excel BUT I need the operation
results in excel.
I succeeded in doing that when my data is homogenous that is to say numeric
in my case.
But when my data is not homogenous - empty cells or strings -, It does not
work.
Ex 3x3 matrix :
9 2 4
4 "blabla" 6
1 (empty) 3
This is not an homogenous matrix. It happens sometimes in my case because of
the data fetched.
In this case, the piece of code shown below does not work. When I log J,
nothing is displayed.
Do you think the problem comes from the way I read the data with Excel ?
regards,
Damien
2007/7/17, Raul Miller <[EMAIL PROTECTED]>:
On 7/17/07, Damien <[EMAIL PROTECTED]> wrote:
> v = Sheet(mySheet).Range(Cells(1,1), Cells(50,50)).Value
> e = js.Set("matrix", v) <== does not work if v is not a matrix of
numeric.
> It it clearer ?
If you eliminate the .Value will it work?
(I think the problem is your data type for v, but I don't know enough
about the environment you are working with to tell you how to
solve that problem.)
--
Raul
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
