How to write character(39) to excel file?
7 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
Friedrich
on 2 Apr 2014
Edited: Friedrich
on 2 Apr 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');
0 Comments
More Answers (1)
Azzi Abdelmalek
on 2 Apr 2014
Edited: Azzi Abdelmalek
on 2 Apr 2014
M={''''''};
xlswrite('Test1.xlsx',M,1,'A1');
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!