Matlab removes excel formulas when writing(saving) files?

2 次查看（过去 30 天）
MKM
MKM 2021-12-1
评论： VBBV 2024-12-24，4:15
[file,path] = uiputfile('*.xlsx');
filename = fullfile(path,file);
writetable(app.newdata,filename);
The code i am using is found above. The original xlsx file contains formulas for certain rows and when i modify the file and resave it, matlab removes all the forumlas in the xlsx file.
Is there an input argument that i can put? i cant seem to see it in the documentations.
Cheers.
  1 个评论
VBBV
VBBV 2024-12-24，4:15
@MKM, use WriteMode property to write /modify the excel file
writetable(app.newdata,filename,'WriteMode','append','Sheet','NewSheet'); % use the write mode property

请先登录，再进行评论。

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

回答（1 个）

Yusuf Suer Erdem
Yusuf Suer Erdem 2021-12-1
Could you try to implement this code below to your system?
[numbers, strings, raw] = xlsread('*.xlsx');

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by