How to overwrite an excel file, matlab 2018?

7 次查看（过去 30 天）
Muazma Ali
Muazma Ali 2023-12-25
评论： Muazma Ali 2023-12-25
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 个评论
显示 2更早的评论
Image Analyst
Image Analyst 2023-12-25
Then just call the writetable function over and over again. It will overwrite the existing file.

请先登录，再进行评论。

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

回答（1 个）

Sulaymon Eshkabilov
Sulaymon Eshkabilov 2023-12-25
Ran in:
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 个评论
Muazma Ali
Muazma Ali 2023-12-25
@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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by