Issue with XLSWRITE on Linux (Red Hat)

Question

prash 2018-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399750-issue-with-xlswrite-on-linux-red-hat

回答： Wasim Aftab 2019-7-8

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更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2018-5-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399750-issue-with-xlswrite-on-linux-red-hat#answer_319291

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