該功能實現(xiàn)將表格數(shù)據(jù)轉(zhuǎn)為一列

import openpyxl

from openpyxlimport Workbook

s_path =r'D:\數(shù)據(jù)治理項目\人才評價樣表\人才評價樣表'

s_file =r'\所屬技術(shù)專家.xlsx'

s_wb =openpyxl.load_workbook(s_path + s_file)

ws2 = s_wb.create_sheet("Sheet2", 2)#創(chuàng)建新Sheet,名稱為Sheet2

s_sheet1 = s_wb['Sheet1']

d_sheet2 = s_wb['Sheet2']

svlist=[]#定義空列表，用于存放源sheet數(shù)據(jù)

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的數(shù)據(jù)賦給變量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]#將列表數(shù)據(jù)寫入到Sheet2的B列

s_wb.save(s_path + s_file)

image.png