如果您查看所使用的方言,则会注意到excel方言的配置如下:
class excel(Dialect):
"""Describe the usual properties of Excel-generated CSV files."""
delimiter = ','
quotechar = '"'
doublequote = True
skipinitialspace = False
lineterminator = '\r\n'
quoting = QUOTE_MINIMAL
@H_403_4@
注意,skipinitialspace@H_403_4@将其设置为False。只需将其传递给您的读者即可。哦,顺便说一句,使用
excel@H_403_4@方言时,您传入的所有字段已经是默认值,这是传递给csv.reader的默认方言参数。 因此,我将像这样重新编写您的代码:
>>> with open(inPath) as fp:
>>> reader = csv.reader(fp, skipinitialspace=True)
>>> for row in reader:
>>> print row,
>>> print len(row)
['hello', 'this is row 1', 'foo1'] 3
['hello', 'this is row 2', 'foo2'] 3
['goodbye', 'this, is row 3', 'foo3'] 3
@H_403_4@