Skip to main content
J
JD_112281864-Participant
4-Participant
March 15, 2026
Solved

JavaScript/VBScript example for getting matrix value

  • March 15, 2026
  • 1 reply
  • 232 views

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

Best answer by terryhendicott

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

 

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

1 reply

T
21-Topaz II
terryhendicott21-Topaz IIAnswer
21-Topaz II
March 15, 2026

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

 

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

J
JD_112281864-ParticipantAuthor
4-Participant
March 15, 2026

Hi Terry,

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

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
March 16, 2026

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

 

Cheers

Terry

Terms & ConditionsCookie settingsAccessibility statement