Hi Andryusha,

This is a bug which was at some point introduced. I have submitted to fix the 
problem in a new release (possibly ver. 8.6 SR2).
Meanwhile, you can use the following script to convert the 1-column matrix 
to MxN matrix: 

GetN (What is the number of Rows in Output?) nr;
range m1=1!1;
nw=m1.nrows;
//range wc=col(1) for wks
//nw=wc.GetSize() for wks
if((nw/nr)==int(nw/nr)) nc=nw/nr; 
else nc=int(nw/nr)+1;
window -t m;
range mm=1!1;
mm.ncols=nc;
mm.nrows=nr;
for(ii=1;ii<=nc; ii++) {
  for(jj=1;jj<=nr; jj++) {
    mm[jj,ii]=m1[nr*(ii-1)+jj];
  }
}

Note that the input data may be more convenient in a worksheet rather than 
in a matrix because as suggested in comment, the number of rows can be 
automatically obtained without bothering the empty cells below.

Hope this is helpful for you.

--Hideo Fujii
OriginLab

// point to excel column
// assuming that it is first col of 1st sheet of book2
range rexcel=[book2]1!1;
// point to the empty matrix you have created
// assuming that it is first matrix object in first sheet of mbook1 
range rmat=[mbook1]1!1;
// simply copy from excel column to matrix
// data will be filled in row-wise, so 1st row, then 2nd row etc
rmat=rexcel;

quote:

---

Originally posted by Hideo Fujii

Hi Andryusha,

No problem! Copy-and-paste all lines of the script into the Script window, then highlight all lines in the Script window, and press ENTER key to run the code.

Hope it works as you wanted.

--Hideo Fujii
OriginLab

---

quote:

---

Originally posted by easwar

Hi,

Here is perhaps a simpler way:

-> First create an empty matrix from the gui/menu and set its dimension by setting desired columns and rows.

-> Then run this code:

// point to excel column
// assuming that it is first col of 1st sheet of book2
range rexcel=[book2]1!1;
// point to the empty matrix you have created
// assuming that it is first matrix object in first sheet of mbook1 
range rmat=[mbook1]1!1;
// simply copy from excel column to matrix
// data will be filled in row-wise, so 1st row, then 2nd row etc
rmat=rexcel;

Easwar
OriginLab

---

quote:

---

Originally posted by Andryusha

Hideo Fujii Posted - 02/10/2012 : 6:20:57 PM

Hi Andryusha,

This is a bug which was at some point introduced. I have submitted to fix the
problem in a new release (possibly ver. 8.6 SR2).


I try evolution version of Origin9 but this bug present in it :( Or may be I'm wrong? I.e. I can't create matrix from 1 column with 2400 cell to matrix with 60 rows and 40 columns by changing Set dimension...


Andryusha

---

quote:

---

Originally posted by Andryusha

Many thanks!!! But after restart Origin we must run @MDA=0 againe? So it is no big problem/// Thank you very much!!!

Andryusha

---