How to overwrite an excel file, matlab 2018?
15 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I need to overwrite an excel file each time write table function runs but I don’t have Matlab 2020. And I cannot delete the file as I am later using it to be uploaded in my app for creating a table in my app.
How can I solve the problem
4 Commenti
Image Analyst
il 25 Dic 2023
Then just call the writetable function over and over again. It will overwrite the existing file.
Risposte (1)
Sulaymon Eshkabilov
il 25 Dic 2023
Here is one code if understood your question correctly:
FName = 'Renew_Table.xlsx';
D = array2table(randi(255, 7, 3))
writetable(D,FName,'Sheet',1);
for ii=1:3
D = readtable(FName);
D{:,:} = D{:,:}*ii;
writetable(D,FName,'Sheet',1);
end
D = readtable(FName)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!