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