How to preserve embedded equations and color coding within Excel when using readtable and writetable?

1 view (last 30 days)
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!

Answers (1)

Walter Roberson
Walter Roberson on 26 Aug 2021
You lose the embedded information in all cases. readtable() only reads the contents of cells.

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!