Excel header title from html code

Question

Julián Francisco 2011-11-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21751-excel-header-title-from-html-code

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2011-11-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21751-excel-header-title-from-html-code#answer_28708

在 MATLAB Online 中打开

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, ')']};