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.

 Akzeptierte Antwort

Azzi Abdelmalek
Azzi Abdelmalek am 3 Jun. 2013
Bearbeitet: Azzi Abdelmalek am 3 Jun. 2013

4 Stimmen

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

9 Kommentare

Lidank Abiel
Lidank Abiel am 3 Jun. 2013
Bearbeitet: Azzi Abdelmalek am 3 Jun. 2013
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 am 3 Jun. 2013
Bearbeitet: Azzi Abdelmalek am 3 Jun. 2013
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 am 3 Jun. 2013
may i know, for what append is used ?
Azzi Abdelmalek
Azzi Abdelmalek am 3 Jun. 2013
Normally append allows to do not erase the previous data;
Lidank Abiel
Lidank Abiel am 3 Jun. 2013
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 am 3 Jun. 2013
No, you have to specify the range
Bheki Ngobe
Bheki Ngobe am 22 Jan. 2016
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 am 26 Dez. 2022
May I know how to make some text bold or change font size while exporting from MATLAB to Excel.
Voss
Voss am 28 Dez. 2022
@Shivam Mishra: Search this forum for "ActiveX Excel" and you will find some examples.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by