How to keep Excel format when using writematrix?
17 views (last 30 days)
Show older comments
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 Comments
Dyuman Joshi
on 27 Mar 2024
"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.
Answers (1)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!