import originpro as op
import numpy as np
mb=op.find_book('m')
ms=mb[0]   #assume it is a 5*5 dimension obj
arr = ms.to_np2d(0)
row1 = arr[0]   #1st row
col3 = arr[:,2] #3rd col
row1=row1+100
col3=col3-200
arr[0]=row1
arr[:,2]=col3
ms2=op.new_sheet('m')
ms2.shape=5,5   #set same size as source mat object
ms2.from_np2d(arr)

quote:

---

Originally posted by minimax

Hi Andrey,

following script with cell() function should also work.

And it is recommended to define range to access.

range rmat1=[Mbook1]Msheet2!2;
rmat1!cell(2,3)=4;

---

quote:

---

Originally posted by aplotnikov

quote:

---

Originally posted by AKazak
https://www.originlab.com/pdfs/5_matrix.pdf does not mention matrix object and implicitly assumes a matrix with a single matrix object in it.

---

It is not true. You can use Mat(n)-notation to access n-th matrix object:

[<Matrix name>]<MSheet>!Mat(<n>)[N*(i-1) + j] = ...

For instance:

[MBook1]1!Mat(2)[66]=66

---

range rmat1=[Mbook1]Msheet2!2;
rmat1!cell(2,3)=4;

quote:

---

Originally posted by AKazak
https://www.originlab.com/pdfs/5_matrix.pdf does not mention matrix object and implicitly assumes a matrix with a single matrix object in it.

---

[<Matrix name>]<MSheet>!Mat(<n>)[N*(i-1) + j] = ...

[MBook1]1!Mat(2)[66]=66

quote:

---

Originally posted by aplotnikov

https://www.originlab.com/pdfs/5_matrix.pdf

Note 2: You can reference a single cell

MatrixName[N*(i-1)+j]
where:
N = the number of columns in the matrix
i = the row number in the matrix.
j = the column number in the matrix.

---

quote:

---

Originally posted by aplotnikov

https://www.originlab.com/pdfs/5_matrix.pdf

Note 2: You can reference a single cell

MatrixName[N*(i-1)+j]
where:
N = the number of columns in the matrix
i = the row number in the matrix.
j = the column number in the matrix.

---