reading and writing files from open office

3 次查看（过去 30 天）
SonOfAFather
SonOfAFather 2012-10-17
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.

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

采纳的回答

Srinivas
Srinivas 2012-10-17
编辑：Srinivas 2012-10-17
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 个评论
显示 1更早的评论
Srinivas
Srinivas 2012-10-17
is there a way you can save your files to '.xls ', or did you try using
importdata
SonOfAFather
SonOfAFather 2012-10-18
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!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by