How to preserve embedded equations and color coding within Excel when using readtable and writetable?
조회 수: 3 (최근 30일)
이전 댓글 표시
Below is how I normally read info out of an Excel file
T = readtable ('example.xlsx','PreserveVariableNames',true);
What if I want to preserve things such as embedded equations, color coding, inserted comments, etc. among the columns with the only change to the Excel file being its column header info, e.g., the first row?
If I just do the below:
T.Properties.VariableNames = something new;
I'll lose info such as embedded info, am I right?
Thanks!
댓글 수: 0
답변 (1개)
Walter Roberson
2021년 8월 26일
You lose the embedded information in all cases. readtable() only reads the contents of cells.
댓글 수: 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!