How can I export a html table to excel ?

2017 2 月 10
1 回答
2020 10 月 2 に更新
3 ビュー (30 日間)

0 投票

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 日

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 についてさらに検索

タグ

質問済み:

Robi
Robi
2017 年 2 月 10 日

回答済み:

Abdesslem Nekkache
Abdesslem Nekkache
2020 年 10 月 2 日

Community Treasure Hunt

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

Start Hunting!

Translated by