openpyxl应用实例（一）

openpyxl应用之整理单元格内容写入新表

//python openpyxl 整理excel数据
# -*- coding: utf-8 -*-
"""
Created on Wed Apr  7 22:34:03 2021

@author: NYY
"""


from openpyxl import load_workbook 
from openpyxl import Workbook
import numpy as np
import pandas as pd

wb = load_workbook('TEST3.xlsx')
ws = wb.active

wb1 = load_workbook('test2.xlsx')
ws1 = wb1.active
JDids=[]
JDpoint=[]


for i in range(1,ws.max_row):
    JDids = ws.cell(row=i, column=1).value
    JDname = ws.cell(row=i, column=2).value
    JDpoints = ws.cell(row=i, column=3).value
    JDpoints = JDpoints.split(',')

    rows_old = ws1.max_row
    
    for j in range(1, len(JDpoints)):
        ws1.cell(row=rows_old+j, column=1).value = JDids
        ws1.cell(row=rows_old+j, column=2).value = j
        ws1.cell(row=rows_old+j, column=3).value = JDname
        ws1.cell(row=rows_old+j, column=4).value = JDpoints[j]
    wb1.save('test2.xlsx')