how to export .mat file into excel sheet
61 次查看(过去 30 天)
显示 更早的评论
i have created a mat file using magic function as follows: Z= magic(4)
Z =
16 2 3 13
5 11 10 8
9 7 6 12
4 14 15 1
W= sign(Z)== -1
W =
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
>> xlswrite('sample.xlsx',W)
Error using xlswrite (line 220) Invoke Error, Dispatch Exception: Source: Microsoft Office Excel Description: Microsoft Office Excel cannot access the file 'C:\Program Files\MATLAB\R2012a\bin\644A5000'. There are several possible reasons:
• The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook. Help File: C:\Program Files\Microsoft Office\Office12\1033\XLMAIN11.CHM Help Context ID: 0
how to save mat file generated by sign function in excel Am i doing right?
0 个评论
采纳的回答
Jan
2016-2-11
The error message means, that you do not have write permissions to the folder 'C:\Program Files\MATLAB\R2012a\bin\ . And it is a very good idea not to polute this folder with data files.
Better write to a well defined location, e.g.:
xlswrite(fullfile(tempdir, 'sample.xlsx'), W)
0 个评论
更多回答(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!