export from matlab to excel

6 次查看（过去 30 天）
Chaudhary P Patel
编辑： stozaki 2020-2-3
sir help me about the commad how can i export my result in to the excel file.

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

回答（3 个）

stozaki
stozaki 2020-2-1
编辑：stozaki 2020-2-1
You can use writematrix or xlswrite.
Please see following URL.
R2019a or later : writematrix
example code
M = magic(5)
writematrix(M,'M.xlsx','Sheet',2,'Range','A3:E8')
R2018b or earlier : xlswrite
exanple code
filename = 'testdata.xlsx';
A = [12.7 5.02 -98 63.9 0 -.2 56];
xlswrite(filename,A)
MATLAB Answers log : https://www.mathworks.com/matlabcentral/answers/?sort=relevance+desc&source=MathWorks+Support&status=accepted&term=xlswrite
  1 个评论
Chaudhary P Patel
Chaudhary P Patel 2020-2-1
sir i did not get your point please clearify it with one example and i am using R2018a.

请先登录，再进行评论。

Chaudhary P Patel
sir, it is not working,
>> filename = 'testdata.xlsx';
A = [12.7 5.02 -98 63.9 0 -.2 56];
xlswrite(filename,A)
Warning: Could not start Excel server for export.
XLSWRITE will attempt to write file in CSV format.
> In xlswrite (line 181)
>>
  7 个评论
显示 5更早的评论
stozaki
stozaki 2020-2-1
编辑：stozaki 2020-2-1
I ran the same script on the following versions, but no problem occurred. And I can't reproduce the warninig.
  • R2015a
  • R2018a
  • R2019b
Workaround: Open the .csv in Microsoft Excel. And SaveAs .xlsx.
If possible, can you reinstall R2018a and try it out?
Image Analyst
Image Analyst 2020-2-1
Are you 100% sure you have Excel installed? Perhaps that might cause a problem.
If you don't have Excel on that computer, use csvwrite() to write a CSV file, which can be opened by WordPad.
Why are you not upgrading to R2019b, where you can get writecell()? It's much, much faster in my experience than xlswrite().

请先登录，再进行评论。

Chaudhary P Patel
sir, i have excel and file is also opening in excel only thing is that i am not getting why this warning is showing there.
  15 个评论
显示 13更早的评论
Walter Roberson
Walter Roberson 2020-2-3
To open it in MATLAB use readtable() not xlsread()
stozaki
stozaki 2020-2-3
编辑：stozaki 2020-2-3
@pramod kumar
Do you solve this problem? I got a similar warning on Linux without Excel installed. You may not have installed Excel correctly. (I know you are using windows10.)
@Walter Roberson @Image Analyst
Thank you for your help.

请先登录，再进行评论。

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by