Skip to main content
JD_112281864-Participant
4-Participant
Mar 15, 2026 2:31 PM UTC
Solved

JavaScript/VBScript example for getting matrix value

Hi,

I looked through the API guide and downloaded the examples. The last part of the code displays 'output1' in message box. It does not have example on how to show the matrixoutput1.

Can you help with this? I need to get matrix from the sheet.

 

Screenshot 2026-03-15 222352.png

terryhendicott
terryhendicottAnswer
21-Topaz II
Mar 15, 2026 11:29 PM UTC

i = matrixValue.SetMatrixElement(0, 0, 2.5);

 

hereResult.MatrixResult.GetMatrixElement(ic, jc, out
dblhere);

View in thread

3 replies

terryhendicott
terryhendicott21-Topaz IIAnswer
21-Topaz II
Mar 15, 2026 11:29 PM UTC

i = matrixValue.SetMatrixElement(0, 0, 2.5);

 

hereResult.MatrixResult.GetMatrixElement(ic, jc, out
dblhere);

Translate
JD_112281864-ParticipantAuthor
4-Participant
Mar 15, 2026 11:49 PM UTC

Hi Terry,

so the matrix can only be operated element by element, is that correct?

Translate
terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Mar 16, 2026 12:20 AM UTC

In terms of getting or setting elements of a matrix, it is as far as I know element by element.

 

Cheers

Terry

Translate
Terms & ConditionsAccessibility statement