how to export .mat file into excel sheet

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?

Answer 1

[Jan]

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)