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 Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by