export from matlab to excel

8 views (last 30 days)
Chaudhary P Patel
Chaudhary P Patel on 1 Feb 2020
Edited: stozaki on 3 Feb 2020
sir help me about the commad how can i export my result in to the excel file.

Answers (3)

stozaki
stozaki on 1 Feb 2020
Edited: stozaki on 1 Feb 2020
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)
  1 Comment
Chaudhary P Patel
Chaudhary P Patel on 1 Feb 2020
sir i did not get your point please clearify it with one example and i am using R2018a.

Sign in to comment.


Chaudhary P Patel
Chaudhary P Patel on 1 Feb 2020
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 Comments
stozaki
stozaki on 1 Feb 2020
Edited: stozaki on 1 Feb 2020
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 on 1 Feb 2020
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().

Sign in to comment.


Chaudhary P Patel
Chaudhary P Patel on 2 Feb 2020
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 Comments
Walter Roberson
Walter Roberson on 3 Feb 2020
To open it in MATLAB use readtable() not xlsread()
stozaki
stozaki on 3 Feb 2020
Edited: stozaki on 3 Feb 2020
@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.

Sign in to comment.

Products


Release

R2018a

Community Treasure Hunt

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

Start Hunting!