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 # 對(duì)A2賦值

wb.close() 關(guān)閉

wb.save(file_path) 保存