How to overwrite an excel file, matlab 2018?
7 views (last 30 days)
Show older comments
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 Comments
Image Analyst
on 25 Dec 2023
Then just call the writetable function over and over again. It will overwrite the existing file.
Answers (1)
Sulaymon Eshkabilov
on 25 Dec 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)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!