How to keep Excel format when using writematrix?

12 次查看（过去 30 天）
Johannes
Johannes 2024-3-27
移动：Dyuman Joshi 2024-3-27
I am working on an app in AppDesigner and I want to export some data in an Excel file. This Excel file is already formatted and prepared for further export (e.g. PDF etc.). When I use the callback (button) in the app to export to Excel using the writematrix command, the data is stored correctly in my Excel sheet. However, Matlab overwrites the cell formatting, especially the column width. So now the Excel sheet is not useable for export and has to be changed again. Is there a way to store the data without altering the format of the cells and to keep the column width? Am I missing something in the writematrix command?
  3 个评论
显示 1更早的评论
Dyuman Joshi
Dyuman Joshi 2024-3-27
So, the data is text i.e. either string or char array(s)?
"Is there a way to store the data without altering the format of the cells and to keep the column width?"
You could try this and see if it works or not - https://in.mathworks.com/help/matlab/ref/writematrix.html#mw_f36f6f84-e6bd-4749-8957-a88b07036116.

请先登录，再进行评论。

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

回答（1 个）

Johannes
Johannes 2024-3-27
移动：Dyuman Joshi 2024-3-27
The option 'AutoFitWidth',0 worked for me, thank you!

类别

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

标签

产品


版本

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by