How can I export a html table to excel ?

4 ビュー (過去 30 日間)
Robi
Robi 2017 年 2 月 10 日
回答済み: 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

サインインしてこの質問に回答する。

回答 (1 件)

Abdesslem Nekkache
Abdesslem Nekkache 2020 年 10 月 2 日
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

カテゴリ

Help Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by