Unable to save excel spreadsheet without being prompted to replace original file
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Image Analyst
am 29 Sep. 2013
You need to turn off alerts:
Excel = actxserver('Excel.Application');
Excel.DisplayAlerts = false; % Suppress Excel warning popups, like for overwriting a file.
2 Kommentare
Shar
am 19 Jan. 2017
Hi, how can I do not overwrite the excel file? I want to save several pics to an excel file without overwriting it!
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!