python脚本——csv模块实现对csv格式Excel操作

一、说明

通过Python 的csv模块，实现对csv格式的Excel文件的一些操作

二、代码

import csv

# 导入需要读取的第一个Excel表格的路径
filename = '****'
err_index = []
err_url = []
err_intro = []

def read_excel():
    with open(filename, newline='') as csvfile:
        reader = csv.reader(csvfile)
        for line in reader:
            err_index.append(line[0])
            err_url.append(line[1])
            err_intro.append(line[2])

def write_excel(row_list):
    with open(filename, "w") as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(['路径', '权限', '类型', '描述'])
        writer.writerows(row_list)

if __name__ == '__main__':
    read_excel()
    for i in range(len(err_index)):
        print(err_index[i], err_intro[i])

三、总结

读：
    with open(filename, newline='') as csvfile:
        reader = csv.reader(csvfile)

写：
	rows = [['1', '2', '3'], ['4', '5', '6']]
	with open(filename, 'w+', newline='') as csv_file:
	    writer = csv.writer(csv_file)
	    for row in rows:
	        writer.writerow(row)