How to write data into an excel file but keep the original formatting?
조회 수: 18 (최근 30일)
이전 댓글 표시
How can I write values into my excel file without changing the formatting that already exists. specifically I want to keep the cell formulas and cell colours unchanged. This is what I have so far but it wipes out all formatting:
writetable(ResultMtx,Result_File);
댓글 수: 1
Mathieu NOE
2021년 8월 25일
hello
have you tried to protect your excel file before your write into it from matlab ?
답변 (1개)
Image Analyst
2021년 8월 25일
편집: Image Analyst
2021년 8월 25일
What release are you using? You forgot to enter it for some reason when you filled out the submission form. Yes that was a problem but I believe they fixed it now. Try release r2021a or later. If I recall correctly, it's no longer blowing away my formatting present in an already-existing workbook.
댓글 수: 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!