python 對Excel操作
2022-01-01 23:20:53

讀取Excel文件

csv.reader函數(shù)最為常用

import csv
with open('excel.csv', 'r') as file:
    for i in csv.reader(file):
        print(i)

寫入Excel文件

csv_write.writerow()將傳入的列表內(nèi)容寫入到一行中

import csv
with open('excel.csv', 'w', newline='') as file:
    csv_write = csv.writer(file)
    csv_write.writerow(['1', '2', '3'])
    csv_write.writerow(['4', '5', '6'])