How to overwrite my data everytime I run my code?

5 vues (au cours des 30 derniers jours)
KD
KD le 13 Août 2024
Commenté : Walter Roberson le 30 Mar 2025
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?

Réponse acceptée

Hassaan
Hassaan le 13 Août 2024
% 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');
  3 commentaires
Image Analyst
Image Analyst le 30 Mar 2025
@Jørgen Are you using Windows? If so you can use ActiveX. See attached for a bunch of Excel utilities.
Walter Roberson
Walter Roberson le 30 Mar 2025
When you call writetable(), specify 'WriteMode', 'overwritesheet'

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Produits


Version

R2023b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by