Excel header title from html code

2011 11 20
1 个回答
回答已采纳
4 次查看（30 天）

0 个投票

I have a GUI with an uitable whose header's title (variable "header") uses html code. I want to export the uitable data (included its header) to an Excel spreadsheet. This is the code written for this task:
%# header = get(htable,'ColumnName');
header = {'<center>Component X<br />(km/s<sup>2</sup>)</center>', ...
'<center>Component Y<br />(km/s<sup>2</sup>)</center>', ...
'<center>Component Z<br />(km/s<sup>2</sup>)</center>'},
numeric_data = rand(3,3);
data_Matrix = [header ; num2cell(numeric_data)],
xlswrite('file.xls',data_Matrix);
However, I can not get Excel spreadsheet header title appears written correctly.

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

 采纳的回答

Jan
Jan 2011-11-21

1 个投票

What happens in the Excel display? Does Excel display HTML formatting at all?
You can try this:
LF = char(10);
Sq = char(178);
header = {['Component X', LF, '(km/s', Sq, ')'], ...
['Component Y', LF, '(km/s', Sq, ')'], ...
['Component Z', LF, '(km/s', Sq, ')']};
[EDITED: Missing quotes inserted]

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Julián Francisco
Julián Francisco 2011-11-21
@Jan Simon: Thank you for your answer. However, I have got the following error:
Expression or statement is incorrect--possibly unbalanced (, {, or [.
for the line corresponding to header.
Jan
Jan 2011-11-21
@Julian: Did you try to fix the problem? I forgot some quotes.
Julián Francisco
Julián Francisco 2011-11-22
@Jan Simon: Yes, I did. Thank you back.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by