将Html的table转换成Excel
2018-06-20 本文已影响0人
norman1981
import pandas
with open('C:\Users\zhaoyingh\Desktop\\a.txt','r') as f:
df = pandas.read_html(f.read(),encoding='utf-8')
bb = pandas.ExcelWriter('out.xlsx')
df[0].to_excel(bb)
bb.close()
