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?

조회 수: 1 (최근 30일)
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
  댓글 수: 1
Guillaume
Guillaume 2019년 10월 17일
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.

댓글을 달려면 로그인하십시오.

채택된 답변

xi
xi 2019년 10월 17일
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
  댓글 수: 5
xi
xi 2019년 10월 18일
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
Sadiq Akbar 2019년 10월 18일
Thank you very much Xi for your interactive responses. And yes, I solved the problem. Thank you once again.
Regards,
Sadiq Akbar

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by