Matlab removes excel formulas when writing(saving) files?

1 回表示 (過去 30 日間)
MKM 2021 年 12 月 1 日
回答済み: Yusuf Suer Erdem 2021 年 12 月 1 日
[file,path] = uiputfile('*.xlsx');
filename = fullfile(path,file);
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.

回答 (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 ExchangeSpreadsheets についてさらに検索




Community Treasure Hunt

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

Start Hunting!

Translated by