# 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?

5 views (last 30 days)

Show older comments

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 Comment

Guillaume
on 17 Oct 2019

### Accepted Answer

xi
on 17 Oct 2019

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

### More Answers (0)

### See Also

### Categories

### Community Treasure Hunt

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

Start Hunting!