export from matlab to excel
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
sir help me about the commad how can i export my result in to the excel file.
0 commentaires
Réponses (3)
stozaki
le 1 Fév 2020
Modifié(e) : stozaki
le 1 Fév 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)
Chaudhary P Patel
le 1 Fév 2020
7 commentaires
stozaki
le 1 Fév 2020
Modifié(e) : stozaki
le 1 Fév 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
le 1 Fév 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().
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!