How to overwrite my data everytime I run my code?

I'm currently writing a program and everytime I run it, it just adds the data to the excel vs deleting the contents of the excel and replacing it with new data. I'm using the writetable function which I thought would automatically clear the excel before filling it with new data. Any ideas?

Answer 1

[Hassaan]

% Your data table
data = table(...); % Replace with your actual data

% Delete the existing file (if it exists)
if exist('your_file.xlsx', 'file')
    delete('your_file.xlsx');
end

% Write the data to an Excel file and overwrite it
writetable(data, 'your_file.xlsx', 'WriteMode', 'overwrite');