reading and writing files from open office

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.

Answer 1

[Srinivas]

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

[SonOfAFather]

it throws an error i think because matlab actually opens office in the background before it uses the data.

[Srinivas]

is there a way you can save your files to '.xls ', or did you try using

importdata

[SonOfAFather]

i have tried that, actually that is what i started with, but for somereason matlab is not happy working with open office. the funny thing is that I can open the file in Matlaab but it will not access the data. I also know that most of my script is right due to the fact that i had it running at class the other day. so i has to be in my laptop...totally frusterating!