How to write data into an excel file but keep the original formatting?

조회 수: 18 (최근 30일)
Hannah
Hannah 2021년 8월 25일
편집: Image Analyst 2021년 8월 25일
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개)

Image Analyst
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.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by