How to export data from matlab to excel

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.

 Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 3 Juin 2013
Modifié(e) : Azzi Abdelmalek le 3 Juin 2013
Example
A=magic(5)
xlswrite('filename.xls',A)
Look at
doc xlswrite
doc xlsread

9 commentaires

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

Connectez-vous pour commenter.

Plus de réponses (0)

Produits

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by