How to write character(39) to excel file?

7 vues (au cours des 30 derniers jours)
Warakorn
Warakorn le 2 Avr 2014
Modifié(e) : Friedrich le 2 Avr 2014
I used the following command
>> xlswrite('Test1.xlsx',char(39),1,'A1');
But when I open Test1.xlsx, I can't see any character in the excel file.
Could you tell me how to write char(39) into excel file?
I used the command below to see what character 39 is >> a = char(39)
a =
'
Thank you very much
OOO

Réponse acceptée

Friedrich
Friedrich le 2 Avr 2014
Modifié(e) : Friedrich le 2 Avr 2014
Hi,
actually the character is written. It's an Excel display feature that it seems like its not there. But when you click at A1 and take a look at the upper text field in Excel (dont know how its called, but the thing which also displays the content of the cell which is currently selected) you will see the '. Basically a single apostrophe does not show up because Excel treats it as a Text marker and not part of the text stream. Enter two apostrophes to get the single quote in the text:
xlswrite('Test1.xlsx',{[char(39),char(39)]},1,'A1');

Plus de réponses (1)

Azzi Abdelmalek
Azzi Abdelmalek le 2 Avr 2014
Modifié(e) : Azzi Abdelmalek le 2 Avr 2014
M={''''''};
xlswrite('Test1.xlsx',M,1,'A1');

Community Treasure Hunt

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

Start Hunting!

Translated by