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

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!

Answer 1

[Walter Roberson]

You lose the embedded information in all cases. readtable() only reads the contents of cells.