Issue with XLSWRITE on Linux (Red Hat)
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(2 个)
Walter Roberson
2018-5-8
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!