How to write special characters into an Excel cell?

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

Leon
Leon le 19 Août 2020
Many thanks! Do you know where I can find a list of the special characters with their Char numbers?
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 Centre d'aide et File Exchange

Produits

Version

R2020a

Tags

Question posée :

le 19 Août 2020

Commenté :

le 19 Août 2020

Community Treasure Hunt

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

Start Hunting!

Translated by