# -*- coding: utf-8 -*-
"""
Created on Sat Oct 29 17:04:57 2022
@author: GAU Bojack.
"""
import csv
from openpyxl import load_workbook
with open('C:/Users/Administrator/Desktop/test.csv','r') as csvfile:
reader = csv.reader(csvfile) ##将列表数据结构转换为元祖数据结构
for ci,rows in enumerate(reader):
rows=tuple(rows)
if ci == 5:
row = rows
if ci == 6:
row1 = rows
print (row)
print (row1)
wb = load_workbook('C:/Users/Administrator/Desktop/demo.xlsx')
#激活excel表
sheet = wb.active
#向excel中写入表头
sheet['a1'] = '年份'
sheet['b1'] = '产量'
data = {
row,
row1,
}
for i in data:
sheet.append(i)
wb.save('C:/Users/Administrator/Desktop/demo.xlsx')
print('数据写入成功!')
利用python处理csv文件的数据
于 2022-10-29 17:39:23 首次发布