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

3 次查看（过去 30 天）
Leon
Leon 2020-2-12
回答： Walter Roberson 2021-8-26
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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by