Unable to save excel spreadsheet without being prompted to replace original file

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?

Answer 1

[Image Analyst]

You need to turn off alerts:

Excel = actxserver('Excel.Application');
Excel.DisplayAlerts = false; % Suppress Excel warning popups, like for overwriting a file.

[vcmorini]

Thank you. Worked nicely.

[Shar]

Hi, how can I do not overwrite the excel file? I want to save several pics to an excel file without overwriting it!