Unable to save excel spreadsheet without being prompted to replace original file
7 次查看(过去 30 天)
显示 更早的评论
Note: This probably has nothing to do with xlsread and xlswrite
My current matlab program attempts to clear a spreadsheet as follows:
Excel = actxserver('Excel.Application');
File = Excel.workbooks.open(path);
%clear the designated range from the designated worksheet
file.worksheets.item(worksheet).range('A:A').clearcontents
invoke(file,'save')
invoke(file,'close')
invoke(Excel, 'quit')
The program runs flawlessly (no syntax errors), but nothing is performed.
The problem I am facing are: 1. Excel will prompt me whether to replace the existing file or not, I want to replace the existing file but I can't just have someone sit around to click yes or no on a 10 hour program 2. The file becomes read only, the file was not read only to begin with (and I made sure of that) 3. Nothing has been cleared
The problem here is the function invoke, I have no idea what it is doing. Is there another way of performing what I am requesting my matlab to do?
0 个评论
回答(1 个)
Image Analyst
2013-9-29
You need to turn off alerts:
Excel = actxserver('Excel.Application');
Excel.DisplayAlerts = false; % Suppress Excel warning popups, like for overwriting a file.
2 个评论
Shar
2017-1-19
Hi, how can I do not overwrite the excel file? I want to save several pics to an excel file without overwriting it!
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!