该功能实现将表格数据转为一列
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