How to export data from matlab to excel

2013 6 3
1 个回答
回答已采纳
更新时间：2022 12 28
10 次查看（30 天）

1 个投票

Hi all. I want to display/export data from matlab to excel, but i dont know how to make it. Can someone help me ? thanks before.

请先登录，再回答此问题。

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-6-3
编辑：Azzi Abdelmalek 2013-6-3

4 个投票

Example
A=magic(5)
xlswrite('filename.xls',A)
Look at
doc xlswrite
doc xlsread

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Lidank Abiel
Lidank Abiel 2013-6-3
编辑：Azzi Abdelmalek 2013-6-3
i've using xlswrite..
nilaieuc=[eucmtkaki; eucmtkamu; eucmtkimu; eucmtkahi; eucmtkihi];
s = xlswrite('dataimg',nilaieuc);
that my code that the result is start from A1 to A5. how to add data to next column ? ( i mean B1 :B5, C1:C5, etc ).
thx before sir.
Azzi Abdelmalek
Azzi Abdelmalek 2013-6-3
编辑：Azzi Abdelmalek 2013-6-3
a=[1;2;3;4;5];
xlswrite('fil21.xls',a);
b=[10;20;30;40;50];
xlswrite('filname.xls',b,'B1:B5','append');
Lidank Abiel
Lidank Abiel 2013-6-3
may i know, for what append is used ?
Azzi Abdelmalek
Azzi Abdelmalek 2013-6-3
Normally append allows to do not erase the previous data;
Lidank Abiel
Lidank Abiel 2013-6-3
so, when I want to store the second data, the first data is not erased? and it will automatically be saved to the next column (B1: B5, C1: C5), is it?
I'm new in using matlab
thanks in advance
Azzi Abdelmalek
Azzi Abdelmalek 2013-6-3
No, you have to specify the range
Bheki Ngobe
Bheki Ngobe 2016-1-22
I tried xlswrite, but each character is printed in its own cell, it does not print it to a single cell iin xlsx.
Shivam Mishra
Shivam Mishra 2022-12-26
May I know how to make some text bold or change font size while exporting from MATLAB to Excel.
Voss
Voss 2022-12-28
@Shivam Mishra: Search this forum for "ActiveX Excel" and you will find some examples.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by