reading and writing files from open office
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
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 个评论
Srinivas
2012-10-17
is there a way you can save your files to '.xls ', or did you try using
importdata
更多回答(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!