How can I export a html table to excel ?

Question

Robi on 10 Feb 2017

0
Link

Direct link to this question

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

Answered: Abdesslem Nekkache on 2 Oct 2020

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