<table>,按順序輸出 CSV。<tr>、</td> 等非標準標簽。python html2csv.py *.html。from HTMLParser import HTMLParser
import re
class Html2Csv(HTMLParser):
def __init__(self):
HTMLParser.__init__(self)
self.csv = ''
self.row = ''
self.in_td = 0
self.in_tr = 0
self.re_space = re.compile(r'\s+')
def handle_starttag(self, tag, attrs):
if tag == 'tr': self._start_tr()
elif tag == 'td': self._start_td()
def handle_endtag(self, tag):
if tag == 'tr': self._end_tr()
elif tag == 'td': self._end_td()
def _start_tr(self):
if self.in_tr: self._end_tr()
self.in_tr = 1
def _end_tr(self):
if self.in_td: self._end_td()
self.in_tr = 0
if self.row:
self.csv += self.row[:-1] + '\n' # 去除尾隨逗號
self.row = ''
def _start_td(self):
if not self.in_tr: self._start_tr()
self.row += '"'
self.in_td = 1
def _end_td(self):
if self.in_td:
self.row += '",'
self.in_td = 0
def handle_data(self, data):
if self.in_td:
clean = self.re_space.sub(' ', data.replace('\t',' ').replace('\n','').replace('\r','').replace('"','""'))
self.row += clean
def get_csv(self, purge=False):
if purge and self.in_tr: self._end_tr()
out, self.csv = self.csv, ''
return out
if __name__ == '__main__':
import sys, glob
for html_file in sys.argv[1:]:
for f in glob.glob(html_file):
parser = Html2Csv()
parser.feed(open(f, 'rb').read())
csv_data = parser.get_csv(purge=True)
out_file = os.path.splitext(f)[0] + '.csv'
open(out_file, 'wb').write(csv_data)
print(f"Converted {f} -> {out_file}")
HTMLParser。from html.parser import HTMLParser。不處理嵌套表格、<pre> 標簽、HTML 實體解碼,如需完整功能建議使用 BeautifulSoup + pandas 方案。