MATLAB: I keep getting an error when trying to run the following command from the MATLAB Fundamentals class (pg 6-11 in course notes). Doesn’t writetable overwrite a file if it already exists

MATLABwritetable error

writetable(standings,'EPLstandings.xlsx')

Error using writetable (line 121) Unable to save the workbook to file 'C:\EPLstandings.xlsx'. Check that write permissions are available, there is sufficient disk space, and the file can be written to or created.

Best Answer

Try the following solution that worked for people with same issue:

After creating the two above-named folders, the MATLAB script's writetable() call now correctly creates the .xlsx file.

 You have to create a folder (or two on a 64bit-windows):
 (32Bit, always)
 C:\Windows\System32\config\systemprofile\Desktop
 (64Bit)
 C:\Windows\SysWOW64\config\systemprofile\Desktop

After creating the two above-named folders, the MATLAB script's writetable() call now correctly creates the .xlsx file.

Related Solutions

MATLAB: Writetable() has write permission problems when run as scheduled task; save() does not

I found a bizarre, totally non-intuitive solution that worked. From Technet.microsoft.com

You have to create a folder (or two on a 64bit-windows):
(32Bit, always)
C:\Windows\System32\config\systemprofile\Desktop
(64Bit)
C:\Windows\SysWOW64\config\systemprofile\Desktop
I have had the same problem and this was the only solution i have found.

After creating the two above-named folders, the MATLAB script's writetable() call now correctly creates the .xlsx file.

MATLAB: Do I get a “SaveAs method of Workbook class failed” error when using the ‘xlswrite’ function

This can occur if the directory you are trying to write to does not exist, or if you don't have write access to that directory. While you can "write" to files which don't previously exist (MATLAB will create them), the directory does need to exist beforehand.

This can also happen in some situations where the user which starts the Excel is a system user. Excel expects the existence of the Desktop directory. To enable the command to work try the following:

For x64 processes create the following folder:

C:\Windows\SysWOW64\config\systemprofile\Desktop

For x86 processes create the following folder:

C:\Windows\System32\config\systemprofile\Desktop

Best Answer

Related Solutions

MATLAB: Writetable() has write permission problems when run as scheduled task; save() does not

MATLAB: Do I get a “SaveAs method of Workbook class failed” error when using the ‘xlswrite’ function

Related Question