python3 表格读写

csv文件读写

import csv

逐列写：

with open('id01.csv', 'w', newline='')as f:

writer = csv.writer(f)

writer.writerows(map(lambda x: [x], id_list))

逐行写

with open('id01.csv', 'w', newline='')as f:

writer = csv.writer(f)

writer.writerow(f)

读取csv文件：

with open('mid01.csv') as file:

file_csv = csv.reader(file)

for row in file_csv:

        print(row)

xlsx文件读写

from openpyxl import load_workbook

file_name ='info01.xlsx'

file_path ='%s.xlsx' % file_name

wb = load_workbook(filename=file_path)

sheet_ranges = wb['sheetname']

print(sheet_ranges['A2'].value) # 成功打印出A2单元格的值说明成功

ws = wb['sheetname']

ws["A2"] = skuid # 对A2赋值

wb.close() 关闭

wb.save(file_path) 保存