Issue with XLSWRITE on Linux (Red Hat)
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I am trying to write some data to Excel using "xlswrite" (Matlab R2015b). It works fine on Window machine but on Linux (Red Hat) I get error " Error using dlmwrite (line 112) The input cell array cannot be converted to a matrix."
Then I commented that line and tried to write regular array. matlab writes in CSV format.
I have "Libre Office " installed on linux which I can use to open the excel.
I even tried "XLWRITE" from mathwork file exchange- I got error
" Error using dlmwrite (line 112) The input cell array cannot be converted to a matrix." I believe it is related to JAVA
0 commentaires
Réponses (2)
Walter Roberson
le 8 Mai 2018
This has nothing to do with java.
xlswrite() tries to use ActiveX to talk to Excel. If it cannot do that (not a Windows machine, or Excel not installed) then it tries to write as CSV, which it can only do for pure numeric data.
I recommend that you switch to writetable(), which is able to write .xls and .xlsx files on Mac and Linux
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!