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!