I have 10 rows and four columns in variable two. I want to write one row in one cell, 2nd row in 2nd cell, 3rd row in 3rd cell and so on into an Excel file using Matlab. How can I do this?

I have a Matrix in Matlab Workspace having floating point data. The order of the matrix is 10x4. I want to write 1st row in A1 cell, 2nd row in A2 cell, 3rd row in A3 cell and so on into an Excel file using Matlab. How can I do that?

Regards,

Sadiq Akbar

[Guillaume]

Why on earth do you want to do this? Excel does not support having several numbers in a cell, so the only way it can be done is by writing the data as text in the cell (easily done if needed) which would make the data useless for further processing in excel.

Answer 1

[xi]

use num2str() to convert your 10X4 numeric matrix into 10 strings.

Then use xlswrite() to write string into Excel cells.

Here's an example

filename='myfile.xlsx';

M=rand(10,4);

str=num2str(M);

for i=1:size(str,1)

xlswrite(filename, cellstr(str(i,:)), 'Sheet1', ['A',num2str(i)]);

end

[Sadiq Akbar]

Thank you very much xi. It worked. But now I have another problem. I have a desired vector like u=[0.5000 1.0000 1.0121 2.011]. I am estimating it using an algorithm.For this I estimate 10 vectors. i.e. I get a matrix of 10x4 size. The name of my matrix is two. But I get it like this:

two=[0.500 1.0214 3.1012 4.0012;

0.9110 0.49909 4.1101 3.0110;

1.0000 0.5000 3.9999 4.1000;

----------------------------------------]

I mean to say sometimes the 1st two elements are swapped with each other and the last two elements are swpped with each other. I don't want swapping. I want to get each time the same order as that of my desired vector u.

Regards,

Sadiq Akbar

[xi]

Are you saying that you want each row to be sorted? then just use sort()

two=sort(two')'

[Sadiq Akbar]

Thank you very much for your prompt response xi. No no, I don't want to sort the row. I think I should re-phrase my question.

I have a desired vector called u and is given by u=[0.5000 1.0000 1.0121 2.011]. I am estimating it using an algorithm. With the help of algorithm, I get 10 vectors having values approximately like u. But the problem is that sometimes the algorithm gives me estimated vector in which the position of element1 is swapped with element2. Likewise, the position of element3 is swapped with element4 which I don't want. I want to get the estimated vector in such a way in which there occures no such swapping. e.g. I get estimated vectors like these:

Estimated=[1.0010 0.5001 2.0011 1.0012]

=[0.5010 1.0101 1.0101 2.0101]

=[1.0110 0.4999 1.9999 1.0001]

------------------------------------------

-------------------------------------------

Comparing these with the desired u, we see that In the 1st Estimated vector, the position of element 1 is swapped with element2. Likewise the position of element3 is swapped with element4. I don't want swapping in estimated vectors like this. I want to get estimated vector in the same order as u always.

Regards,

Sadiq Akbar

[xi]

Hi Sadiq,

I don't get what is the hard part that prevent you from realizing it?

Just make a judgement of whether it is swapped or not and then process it accordingly.

There are many ways you can choose to make such judgement: for example, you can do a pearson correlation between the estimated and the desired, for all the possible mutants upon swapping, and then choose the one with the hightest correlation score.

Xi

[Sadiq Akbar]

Thank you very much Xi for your interactive responses. And yes, I solved the problem. Thank you once again.

Regards,

Sadiq Akbar