writetable resizing column widths

26 次查看（过去 30 天）
Calvin Ebert
Calvin Ebert 2019-5-8
评论： Danny Smith 2022-11-15
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 个评论
Danny Smith
Danny Smith 2022-11-15
I was able to avoid auto-resizing of Excel columns when using writetable via a 2-step process:
  • 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)

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Calvin Ebert
Calvin Ebert 2019-7-31
Hey anyone reading this, there is a work around but it is kinda annoying. See how you want your columns sized and fill in a row with 'a's at the very very end where it doesnt touch anything (Or at the very top) and have it read (Or save as variable and keep) and write it last.
  1 个评论
Alex Calder
Alex Calder 2020-10-29
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.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2019-5-8
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by