Writematrix without autofi column width

11 次查看（过去 30 天）
Dwight Schrute III
回答： Walter Roberson 2019-6-6
When I use writematrix to paste a matrix into an Excel file, the column widths are then adjusted to autofit the length of the pasted matrix. Is there a way to prevent this from happening, i.e., to retain the original Excel column width prior to pasting?

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

采纳的回答

Walter Roberson
Walter Roberson 2019-6-6
No, not using writematrix() . The widths are controlled by metadata about the cells that writematrix() makes no attempt to control.
In order to control the widths, you would need to be using MS Windows with Excel installed, and you would have to use activex to connect to excel and give it commands to control the cell formatting.

更多回答（0 个）

类别

在 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