How to keep Excel format when using writematrix?
조회 수: 18 (최근 30일)
이전 댓글 표시
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
Dyuman Joshi
2024년 3월 27일
"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개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!