How can I export a html table to excel ?

Question

Robi 2017-2-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/324360-how-can-i-export-a-html-table-to-excel

回答： Abdesslem Nekkache 2020-10-2

Hello everyone,

I have a html table defined by a cell array. Example:

tab = {'<html><table border = 0 width = 400 bgcolor = #FF00FF;><TR><TD> text </TD></TR> </table></html>'
    '<html><table border = 0 width = 400 bgcolor = #FFFF00;><TR><TD> text </TD></TR> </table></html>'
    '<html><table border = 0 width = 400 bgcolor = #00FFFF;><TR><TD> text </TD></TR> </table></html>'};

I would like to export this table to excel with all its properties (colors, font size...). When I use xlswrite it does not work: matlab writes the html codes directly in the cells.

Do you have any idea ?

Thanks