Excel header title from html code

3 次查看（过去 30 天）
Julián Francisco
Julián Francisco 2011-11-20
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
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更早的评论
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 个）

类别

在 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