Read from a html file and paste part of content into a excel file

[srgunukula]

I have a html file(report.htm) which points to another html file(summary.html). the summary.html has some data and a table with multiple row entries.

I have to copy only the table (along with column names ) from summary.html and paste in the same order and column wise to an excel file.

The column size is fixed to 10 , but the number of rows some times may increase or decrease .
Column names are :
Transaction Name SLA Status Minimum Average Maximum Std. Deviation 90 Percent Pass Fail Stop


attaching report.htm and summary.html files here changing extension to .txt

No issue using python or shell or VB script. preferred is Python.