How to overwrite my data everytime I run my code?

Question

Abigail 2024-8-13，11:12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2144969-how-to-overwrite-my-data-everytime-i-run-my-code

回答： Hassaan 2024-8-13，11:28

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Hassaan 2024-8-13，11:28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2144969-how-to-overwrite-my-data-everytime-i-run-my-code#answer_1498449

在 MATLAB Online 中打开

% 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');