How to write data into an excel file but keep the original formatting?
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Mathieu NOE
am 25 Aug. 2021
hello
have you tried to protect your excel file before your write into it from matlab ?
Antworten (1)
Image Analyst
am 25 Aug. 2021
Bearbeitet: Image Analyst
am 25 Aug. 2021
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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!