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!

답변 (1개)

Walter Roberson
Walter Roberson 2021년 8월 26일
You lose the embedded information in all cases. readtable() only reads the contents of cells.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by