#讀成列表：
with open(address,'r') as fin:
cin = csv.reader(fin)
out = [row for row in cin]
print(out)#是一個(gè)列表农渊，每行也是個(gè)列表
#讀成字典：
#原本沒有表頭：
with open(address,'r') as fin:
cin = csv.DictReader(fin,filenames=['first','last'])
out = [row for row in cin]
print(out)
#原本有表頭：
with open(address,'r') as fin:
cin = csv.DictReader(fin)
out = [row for row in cin]
print(out)
xlrd模塊
讀取
import xlrd
address = 'test.xls'
def read_xls():
outdata = []
data = xlrd.open_workbook(address)
table = data.sheets()[0]
title = table.row_values(0)
for row in range(2, table.nrows):
rn = [i.strip() for i in table.row_values(row)]
d = {k: v for k, v in zip(title, rn)}
#print(d)
outdata.append(d)
return outdata
