How to overwrite an excel file, matlab 2018?

7 views (last 30 days)
Muazma Ali
Muazma Ali on 25 Dec 2023
Commented: Muazma Ali on 25 Dec 2023
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
Image Analyst on 25 Dec 2023
Then just call the writetable function over and over again. It will overwrite the existing file.

Sign in to comment.

Answers (1)

Sulaymon Eshkabilov
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))
D = 7×3 table
Var1 Var2 Var3 ____ ____ ____ 253 86 140 111 16 208 12 135 161 91 74 185 25 158 122 252 253 83 71 101 77
writetable(D,FName,'Sheet',1);
for ii=1:3
D = readtable(FName);
D{:,:} = D{:,:}*ii;
writetable(D,FName,'Sheet',1);
end
D = readtable(FName)
D = 7×3 table
Var1 Var2 Var3 ____ ____ ____ 1518 516 840 666 96 1248 72 810 966 546 444 1110 150 948 732 1512 1518 498 426 606 462
  1 Comment
Muazma Ali
Muazma Ali on 25 Dec 2023
@Sulaymon Eshkabilov I dont really understand what you are doing here; I dont think I can apply this as I have both number and text as part of my table

Sign in to comment.

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!