How can I export a html table to excel ?

2 vues (au cours des 30 derniers jours)
Robi
Robi le 10 Fév 2017
Réponse apportée : Abdesslem Nekkache le 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

Connectez-vous pour répondre à cette question.

Réponses (1)

Abdesslem Nekkache
Abdesslem Nekkache le 2 Oct 2020
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

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by