- In the Excel file/sheet you are writing to, go to Review>>Protect Sheet. Make sure that 'Format Columns' and 'Format Rows' are unchecked, then press OK
- When using writetable with the protected sheet, use the Name/Value pair ('UseExcel', true)
writetable resizing column widths
25 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Calvin Ebert
am 8 Mai 2019
Kommentiert: Danny Smith
am 15 Nov. 2022
I am using the following:
writetable(Variable ,'Location', 'Sheet', 'Sheet Name', 'Range', Range, 'WriteVariableNames', false)
It works correctly in writing although it resizes the columns in excel. It is writing to the end of an existing table. Is there any way to avoid this?
1 Kommentar
Danny Smith
am 15 Nov. 2022
I was able to avoid auto-resizing of Excel columns when using writetable via a 2-step process:
Akzeptierte Antwort
Calvin Ebert
am 31 Jul. 2019
1 Kommentar
Alex Calder
am 29 Okt. 2020
Can you please provide an example, or link to where one is given? Your comment doesn't make it clear exactly what info you are wrting where and in what order. Thanks.
Weitere Antworten (1)
Walter Roberson
am 8 Mai 2019
No, there is no way to avoid it with writetable(). writetable() does not attempt to preserve formatting or templates or graphics or formulas written into the range.
To have any of those preserved, you need to use actxserver() or a .NET interface to talk to Excel to tell it what needs to be done.
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!