How to write special characters into an Excel cell?

11 vues (au cours des 30 derniers jours)
Leon
Leon le 19 Août 2020
Commenté : Leon le 19 Août 2020
I'm trying to write the units of my table into the 2nd row of my Excel file. Below is the code:
writecell(T.Properties.VariableUnits,filename,'Range',"A2")
My question is how do I write special characters into the cells?
T1.Properties.VariableUnits = {'\circC', '\Omega', '\mumol/kg'};
Many thanks.

Réponse acceptée

Sindar
Sindar le 19 Août 2020
If you can find the numeric code for the symbols, it should print with that. For example, this prints π | ϕ | μmol/kg
T1.Properties.VariableUnits = {char(960), char(981), [char(956) 'mol/kg']};
writecell(T1.Properties.VariableUnits,filename,'Range',"A2")
  3 commentaires
Sindar
Sindar le 19 Août 2020
I do not. Usually, I'll do something like
char(900:1000)
and skim through the list, doing a rough binary search for the right number (that's how I found the ones above). Greek letters should be together and ordered, not sure where degree would be
Leon
Leon le 19 Août 2020
Many thanks!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Characters and Strings dans Help Center et File Exchange

Tags

Produits


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by