Issue with XLSWRITE on Linux (Red Hat)

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

Answer 1

[Walter Roberson]

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

[prash]

I am getting another error with writetable "Could not start Excel server for export - export to text file instead"

[Walter Roberson]

http://www.openoffice.org/api/

Use the Java API inside MATLAB to write to the file.

Answer 2

[Wasim Aftab]

Why not using writetable(data, 'filename.xlsx')?