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')