I am sorry for my bad english.
Let's consider this example :
I have an excel sheet with 2 matrices 50 x 50 in the same sheet. One above
the other with some space between. My idea is to read these matrices thanks
to a macro, ask J to do a multiplication between these 2 matrices and then
display the result somewhere in the excel sheet.
Theorically, the matrices are made of numeric. But if by chance there is an
empty cell or a cell with a string within the matrix instead of a numeric, i
can not send the matrix to J, I do not why. It works only if all the data
are numeric.
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 ?
Damien.
2007/7/17, bill lam <[EMAIL PROTECTED]>:
Still cannot understand your problem, could you give an actual example for
discussion?
Damien wrote:
> By wrong data, I mean a cell with nothing inside - an empty cell - or a
> cell
> with a string instead of a numeric.
> I just want to read some matrices within Excel and execute some
calculation
> with J, but if the cells have not a number, it does not work.
>
> Damien.
>
> 2007/7/17, Devon McCormick <[EMAIL PROTECTED]>:
>>
>> Can you give an example of what you're doing? What do you mean by
"wrong
>> data"?
>>
>> On 7/17/07, Damien <[EMAIL PROTECTED]> wrote:
>> >
>> > Hello,
>> >
>> > I am currently using J as server for Excel with OLE. I would like to
>> deal
>> > with the problem of empty cells or wrong type of value (string) with
J,
>> > and
>> > not with Excel.
>> > The problem is that I can not send any "wrong" data to J. When the
data
>> > are
>> > correct, J receives them as boxed array. As boxed arrays rare very
>> > convenient to deal with different type of data, I am a little
>> surprised.
>> > Do you know if it is possible to do what I want ?
>> >
>> > Thanks.
>> > Damien.
>> >
----------------------------------------------------------------------
>> > For information about J forums see
http://www.jsoftware.com/forums.htm
>> >
>>
>>
>>
>> --
>> Devon McCormick, CFA
>> ^me^ at acm.
>> org is my
>> preferred e-mail
>> ----------------------------------------------------------------------
>> For information about J forums see http://www.jsoftware.com/forums.htm
>>
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
