如果您查看所使用的方言,则会注意到excel方言的配置如下:
class excel(Dialect): """Describe the usual properties of Excel-generated CSV files.""" delimiter = ',' quotechar = '"' doublequote = True skipinitialspace = False lineterminator = 'rn' quoting = QUOTE_MINIMAL
注意,
skipinitialspace将其设置为False。只需将其传递给您的读者即可。哦,顺便说一句,使用
excel方言时,您传入的所有字段已经是默认值,这是传递给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



