MATLAB: Reading and writing files from open office

data importimporting excel dataMATLAB

I know that i can use dlmread and dlmwrite to work with .txt files, and i can use xlsread and xlswrite for excel files.
But i do not have microsoft office on my computer. I use open office, and and trying to open,use, and rewrite an excel file.
here is the error:
Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP XLSREAD for more information.
> In xlsread at 186
In singletary7 at 3
Warning: Could not start Excel server for export.
XLSWRITE will attempt to write file in CSV format.
> In xlswrite at 175
In singletary7 at 54
Error using xlswrite (line 188)
An error occurred on data export in CSV format.
Error in singletary7 (line 54)
xlswrite('student_grades_singletary.xlsx', newData);
Caused by:
    Error using dlmwrite (line 118)
    The input cell array cannot be converted to a matrix.

Best Answer

did u try using xlsread u should be able to read files. I am not sure of xlswrite
edit:
from the help file of xlsread
if your system does not have Excel for Windows, xlsread operates in basic import mode, and only reads XLS files compatible with Excel 97-2003 software
Related Question