xlrd读取
import xlrd
sheet3 = book.sheets()[2]
row3 = sheet3.nrows
for i in range(row3):
l3.append(sheet3.row_values(i))
csv写入
f = open('Q3_2018_关联度.csv', mode='w',encoding='utf-8',newline='')
csv_writer = csv.writer(f)
csv_writer.writerow(temp)
f.close()
csv_writer= csv.DictWriter(f,fieldnames=[]) #写入列名 csv_writer.writeheader() csv_writer.writerow(dic)
