Export data from MATLAB to Excel

Question

ghazale 2013-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74322-export-data-from-matlab-to-excel

I want to export my data from MATLAB to Excel, I now the Excel write code, just I want to organiye data in Excel by Matlab. I have 3 columns that they don't have the same number of rows, I want to put them near each other with a gap in between.like :

 Time   Rate     Temp
 12     23       543
 13     32       3
 43     432      435
 123    23       2
        23423    234234 
                 23

Is it possible?

Thanks

[EDITED, Jan, table formatted]

2 个评论
显示无隐藏无

Jan 2013-5-2

编辑：Jan 2013-5-2

I'm not sure if I understand you correctly. You know how to write the data in Excel. Then what is the problem? Where is the "gap"?

Zhang lu 2013-5-2

编辑：Zhang lu 2013-5-2

Hi

xlswrite('a.xls',{'Time'},'sheet1','A1'); xlswrite('a.xls',{'Rate'},'sheet1','B1'); xlswrite('a.xls',{'Temp'},'sheet1','C1'); xlswrite('a.xls',Time,'A2:A5'); xlswrite('a.xls',Rate,'B2:B6'); xlswrite('a.xls',Temp,'C2:C7');

请先登录，再进行评论。

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

Answer 1

Habib 2013-5-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74322-export-data-from-matlab-to-excel#answer_84186

在 MATLAB Online 中打开

after you have your vectors calculated as below:

R1=your_time_vector; % here[12; 13; 43; 123] 
R2=your_rate_vector;
R3=your_temp_vector;

you create a header vector:

R0={'Time' , 'Rate' ,'Temp'};

and then export your results to Results.xlsx as below:

    xlswrite('Results.xlsx', R0,'Sheet1','A1');
    xlswrite('Results.xlsx', R1,'Sheet1','A2');
    xlswrite('Results.xlsx', R2,'Sheet1','B2');
    xlswrite('Results.xlsx', R3,'Sheet1','C2');