Creating .xlsx files with formatted HTML content

Can we support the request to insert data from HTML tables into excel files?

You can try using the StripHTML() function to strip the HTML tags and get text in string format, and the REST API functionality to retrieve your data.
We can look into getting HTML as a source in future. Please follow the same post to stay updated.