如何将html转换成csv,如何将HTML表格转换为CSV？

Yuval..

9

这是我编写的一个简短的Python程序来完成这项任务.它是在几分钟内编写的,所以它可能会变得更好.不确定它将如何处理嵌套表(可能它会做坏事)或多个表(可能它们只是一个接一个地出现).它没有处理colspan或rowspan.请享用.

from HTMLParser import HTMLParser

import sys

import re

class HTMLTableParser(HTMLParser):

def __init__(self, row_delim="\n", cell_delim="\t"):

HTMLParser.__init__(self)

self.despace_re = re.compile(r'\s+')

self.data_interrupt = False

self.first_row = True

self.first_cell = True

self.in_cell = False

self.row_delim = row_delim

self.cell_delim = cell_delim

def handle_starttag(self, tag, attrs):

self.data_interrupt = True

if tag == "table":

self.first_row = True

self.first_cell = True

elif tag == "tr":

if not self.first_row:

sys.stdout.write(self.row_delim)

self.first_row = False

self.first_cell = True

self.data_interrupt = False

elif tag == "td" or tag == "th":

if not self.first_cell:

sys.stdout.write(self.cell_delim)

self.first_cell = False

self.data_interrupt = False

self.in_cell = True

def handle_endtag(self, tag):

self.data_interrupt = True

if tag == "td" or tag == "th":

self.in_cell = False

def handle_data(self, data):

if self.in_cell:

#if self.data_interrupt:

# sys.stdout.write(" ")

sys.stdout.write(self.despace_re.sub(' ', data).strip())

self.data_interrupt = False

parser = HTMLTableParser()

parser.feed(sys.stdin.read())