Matlab removes excel formulas when writing(saving) files?
조회 수: 5 (최근 30일)
이전 댓글 표시
[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
2024년 12월 24일 4:15
writetable(app.newdata,filename,'WriteMode','append','Sheet','NewSheet'); % use the write mode property
답변 (1개)
Yusuf Suer Erdem
2021년 12월 1일
Could you try to implement this code below to your system?
[numbers, strings, raw] = xlsread('*.xlsx');
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!