openpyxl读取存储数据

python的openpyxl的Excel的数据转为列表之后，写入表格中并保存

#encoding:utf-8
import numpy as np
from openpyxl import Workbook, load_workbook
wb = Workbook()
wp = load_workbook('text01.xlsx')
#获取读取工作蒲的名字，来命名新的工作蒲的明
readwork_name = wp.sheetnames
# 定义一个函数接受一个参数用于读取第几个工作蒲
# 5,7,17
def read_workbookindex(index_on):
    sheet = wp.worksheets[index_on]
    # 用于获取剩下列数的列表的index来读取剩下需要的数据
    table_name = ["接入时间","联调情况" ,"生产调通/上线日期"]
    ws = wb.create_sheet(readwork_name[index_on])
    data_thre =[]
    read_prethre_1 = []
    read_prethre_2 = []
    read_prethre_3 = []
    col_data = []
    for col in sheet.iter_cols():
        colm = col[0]
        col_data.append(colm.value)
    print(col_data)
    # list.index(5)
    # J用于数据写入第几列
    j =4
    for i in table_name:
            arr_data = []
            num= col_data.index(i)
            print(num)
            for row in sheet.iter_rows():
                row_val = row[num]
                arr_data.append( row_val.value)

            for k in range(len(arr_data)):
                ws.cell(row= k+1,column=j).value=arr_data[k]
            j +=1
    for  i in range(0,3):
        if i == 0:
            print(123123)
            for rows in sheet.iter_rows():
                row = rows[0]
                read_prethre_1.append(row.value)
                data_thre.append(read_prethre_1)
            for i in range(len(read_prethre_1)):
                 ws.cell(row=i+1,column=1).value = read_prethre_1[i]
        if i == 1:
              for rows in sheet.iter_rows():
                  row = rows[1]
                  read_prethre_2.append(row.value)
                  data_thre.append(read_prethre_2)
              for i in range(len(read_prethre_2)):
                ws.cell(row=i+1,column=2).value = read_prethre_2[i]
                  
        if i == 2:
            for rows in sheet.iter_rows():
                  row = rows[2]
                  read_prethre_3.append(row.value)
                  data_thre.append(read_prethre_3)
            for i in range(len(read_prethre_3)):
                ws.cell(row=i+1,column=3).value = read_prethre_3[i]       
        
    print(len(np.array(data_thre).shape))
    return data_thre
# print(read_workbookindex(0))
read_workbookindex(0)
read_workbookindex(1)
read_workbookindex(2)
# print(read_data[1])
#二维数据的写入
# for i in range(len(read_data)):
#     for j in range(len(read_data[i])):
#        data = [i][j]
#        ws.cell(row =i+1,column=j+1).value=data
#     # ws.append(row)
wb.save('20221019data03.xlsx')
wb.close() 

本人小白很，梗python学习的一天记录于20221020