How can I export a html table to excel ?
显示 更早的评论
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
回答（1 个）
Abdesslem Nekkache
2020-10-2
0 个投票
I can help you if you give me a real html page, because your table is very small,
give me a full table and I will try to help you.
If you want to convert only table to csv the link below can help you
I can explain it for you.
https://www.mathworks.com/matlabcentral/fileexchange/34968-htmltabletocell
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2020-10-2
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
