Issue with XLSWRITE on Linux (Red Hat)
조회 수: 9 (최근 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!