writetable() has write permission problems when run as scheduled task; save() does not
显示 更早的评论
I have a script that checks a folder for accumulating images, processes them, and builds a table of data about the images. The script then saves the table in two ways: first, as a .mat file via the MATLAB save() function, and then as an Excel spreadsheet via the writetable() function into the very same folder.
The script works perfectly in an interactive MATLAB window.
However, when I try to run the script via Windows' Task Scheduler, the writetable part fails due to a permissions error while the save() works just fine to the very same location. I have given the scheduled task my user credentials, and the fact that the .mat file gets written suggests to me that the script has write permission the folder. writetable chokes, however.
The error I get (seen via the -logfile parameter to MATLAB in the scheduled task) is:
Unable to save the workbook to file 'D:\ImageList2017-03-30.xlsx'. Check
that write permissions are available, there is sufficient disk space, and
the file can be written to or created.
And the error points to:
C:\Program Files\MATLAB\R2016b\toolbox\matlab\iofun\writetable.m line 121.
This is on Windows 7, writing to a local disk (eventually I want it to work with an UNC path to a shared folder), using MATLAB R2016b.
Ideas?
Edit for additional information: I changed the filetype of the file being written by writetable() to be .txt, and that worked just fine with no permission errors. So this seems to be an issue with writing .xlsx. Is Microsoft Office misbehaving here?
4 个评论
Scott
2017-3-30
Jan
2017-3-31
Please post this as an answer.
Victor Villar
2019-5-24
编辑：Victor Villar
2019-5-24
Maybe this could help:
https://www.mathworks.com/matlabcentral/answers/463778-windows-task-scheduler-does-not-produce-any-output-when-setting-tasks-with-xlswrite
Tharikaa Ramesh Kumar
2024-6-12
Do you run time-consuming tasks on MATLAB and Simulink? Do you wish you could schedule them and run them in the background, unattended? How do you solve this question today?
MATLAB Product team is very interested to talk to you and learn from your experience. Please participate in this brief survey (6 questions).
采纳的回答
Scott
2020-2-3
2 个评论
Zeynab Mousavikhamene
2020-6-18
I pefromed above solution and it did not work. Then I shortened the address and it worked. It seems there is a limitation in the size of the address.
The second note mentioned by Zeynab Mousavikhamene worked for me. I was trying to save my table to (C:\Program Files\New Folder) and it did not work. I changed to C:\New_Folder (with no space) and it worked just fine. Thank you Zeynab and Scott for your contributions.
更多回答（3 个）
Ahmed Rashid
2020-1-31
0 个投票
The error might also occur if the folder, in which the file is supposed to be save, does not exist.
1 个评论
Monika Zunji
2021-6-9
That folder exists but this error occurs for me too
Derek Smith
2022-9-23
0 个投票
As the exact filename you are attempting to write is not given, I figure I can lend my $0.02. My problem was that, when trying to name a file according to a date, I did not format the date to remove colon markers. Once these illegal characters were removed, there was no problem.
Tharikaa Ramesh Kumar
2024-6-12
0 个投票
Do you run time-consuming tasks on MATLAB and Simulink? Do you wish you could schedule them and run them in the background, unattended? How do you solve this question today?
MATLAB Product team is very interested to talk to you and learn from your experience. Please participate in this brief survey (6 questions).
类别
在 帮助中心 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
