reading and writing files from open office

6 views (last 30 days)
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.

Accepted Answer

Srinivas
Srinivas on 17 Oct 2012
Edited: Srinivas on 17 Oct 2012
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
  3 Comments
SonOfAFather
SonOfAFather on 18 Oct 2012
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!

Sign in to comment.

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!