reading and writing files from open office

Question

SonOfAFather 2012-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/51142-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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Srinivas 2012-10-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/51142-reading-and-writing-files-from-open-office#answer_62307

编辑：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更早的评论隐藏 1更早的评论

Srinivas 2012-10-17

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

importdata

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!

请先登录，再进行评论。