How to write character(39) to excel file?

5 次查看（过去 30 天）
Warakorn
Warakorn 2014-4-2
编辑： Friedrich 2014-4-2
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

请先登录，再回答此问题。

采纳的回答

Friedrich
Friedrich 2014-4-2
编辑：Friedrich 2014-4-2
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');

更多回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2014-4-2
编辑：Azzi Abdelmalek 2014-4-2
M={''''''};
xlswrite('Test1.xlsx',M,1,'A1');

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by