Export data from MATLAB to Excel

2 次查看（过去 30 天）
ghazale
ghazale 2013-5-2
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
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
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');

请先登录，再进行评论。

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

回答（1 个）

Habib
Habib 2013-5-2
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');

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by