Error using writecell() : Permission denied

3 次查看（过去 30 天）
Nicholas Brophy
Nicholas Brophy 2020-11-30
回答： Nicholas Brophy 2020-12-1
I currently have code in FolderA which runs a function that needs to access csv files in FolderB, but I am being denied permission to edit/enter the folder and its contents, though I (should) have full admin privilages on my computer.
folder = 'C:\Users\...\FolderA\...\FolderB' % folder I want to access containing several csv files
if ~exist(folder, 'dir')
mkdir(folder);
end
fullFileName = fullfile(folder, 'SRM_design.csv');
titles={'A', 'B', 'C', 'D','E','F','G','H','I','J'};
M={300,1,0.05,625,14.7,12.4,0,1,15,0.97};
M=[titles;M];
fname='fullFileName';
writecell(M,fullFileName);
When I run the above within my function, I get this error:
Error using writecell (line 149)
Unable to open file 'C:\Users\...\FolderA\...\FolderB\filename.csv' for writing:
Permission denied
When I run the same function within FolderB it works fine.
I will need to access this folder several times within the code and will need access to the files edited within FolderB.

请先登录，再回答此问题。

采纳的回答

Nicholas Brophy
Nicholas Brophy 2020-12-1
Checked to reconfirm function runs properly within Folder B. When it didn't work I realized that the document was open in excel and therefore locked for editing. After closing the document it worked just fine again within both folders.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by