Excel header title from html code

3 Ansichten (letzte 30 Tage)
Julián Francisco
Julián Francisco am 20 Nov. 2011
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.

Akzeptierte Antwort

Jan
Jan am 21 Nov. 2011
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 Kommentare
Jan
Jan am 21 Nov. 2011
@Julian: Did you try to fix the problem? I forgot some quotes.
Julián Francisco
Julián Francisco am 22 Nov. 2011
@Jan Simon: Yes, I did. Thank you back.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by