Python读写excel

1.导入csv模块

2.reader()：读取

3.writerow()：写入

1.读取数据

import csv
path=r"C:\Users\csv\my.csv"
reader=csv.reader(open(path,"r")) #读取文件
for  item  in reader:#读取每一行
    #print(item)  list  itten[13]
    for data in item: #读取每一列
        print(data)

2.写入数据

import csv
#with open("C:\\Users\\pc\\Desktop\\my.csv","w",newline="") as  datacsv:


csvw=csv.writer(open("C:\\Users\\pc\\Desktop\\my.csv","w",newline=""),dialect=("excel")) #最常用excel格式
csvw.writerow(["1","2","3","4","5"])
csvw.writerow(["1", "2", "3", "4", "5"])