该功能实现将表格数据转为一列

import openpyxl

from openpyxlimport Workbook

s_path =r'D:\数据治理项目\人才评价样表\人才评价样表'

s_file =r'\所属技术专家.xlsx'

s_wb =openpyxl.load_workbook(s_path + s_file)

ws2 = s_wb.create_sheet("Sheet2", 2)#创建新Sheet,名称为Sheet2

s_sheet1 = s_wb['Sheet1']

d_sheet2 = s_wb['Sheet2']

svlist=[]#定义空列表，用于存放源sheet数据

for s_row_idxin range(1, s_sheet1.max_row +1):

    for s_col_idxin range(ord('a'), ord('z') +1):

        sv = s_sheet1[chr(s_col_idx) +str(s_row_idx)].value#将读取源sheet的数据赋给变量sv

        svlist.append(sv)#将变量sv追加到空列表

svlist =[ifor iin svlistif i !=None]#列表去空值

print(svlist)

for nin range(0,len(svlist)):

    d_sheet2['B' +str(n+1)].value = svlist[n]#将列表数据写入到Sheet2的B列

s_wb.save(s_path + s_file)

image.png