Extracting data from excel and rewrite it into specific cell in a loop

Hello all, im new to matlab and wondering how do you extra the data from excel and rewrite it into specific cells format as shown below.

into this format below

[Fangjun Jiang]

No idea what is the relationship between these two sets of data.

[LIM JIAXIN]

Hi Jun Jiang, what i am trying to do is to move the column H into a column of cell M for example. So for example, H2 will move to M1, H1 to M2, M3 will be the number of A3:A7, H3:H7 to M4

Answer 1

[Bob Thompson]

The basic method for extracting data from Excel into Matlab is to use the xlsread() command. I would suggest reading all of the data you are interested in first, and then organizing the data within Matlab. At that point, moving the data is simply a matter of indexing and loops or condition statements.

[LIM JIAXIN]

Hi Bob, i understand the use of xlsread() command as i would required the whole data. above are just the examples and i have no idea how to write the indexing

[Bob Thompson]

Indexing is fairly simple. The super basics in two sentences is to use some form of brackets attached as a suffix to the array variable. Inside the brackets you need to have indicators for which element in which direction you want (i.e. first is row, second is column, then third dimension, fourth dimension, etc.).

data(1,3) % Element it first row, third column of array
data{1,3} % Element CONTENTS in first row, third column of cell array.

For your case you might be looking to do something like this:

rawdata = xlsread(filename,sheet,range);
data(2,1) = rawdata(2,8); % H2 to M1

[LIM JIAXIN]

I try reading from range A:H. and rewrite it into Sheet2. However the data come out is different from the original data as it just show 0 and 1.