本文提供兩種思路供大家參考：

import xlwt
import openpyxl
from openpyxl import Workbook, workbook
from openpyxl import load_workbook
from openpyxl.writer.excel import ExcelWriter

def copy_and_stick(m,n):
    wb = load_workbook('E:\\PythonProgram\\test_new.xlsx')
    ws = wb['網(wǎng)級(jí)數(shù)據(jù)']# sheet名稱
    sheet = wb.active
    a = sheet.max_row
    b = []
    i = 0
    while i < a:
        i = i + 1
        print(ws.cell(i, m).value)
        b.insert(i, ws.cell(i, m).value)

    wbtest = load_workbook('E:\\PythonProgram\\test1.xlsx')# 目標(biāo)路徑
    ws = wbtest['Sheet1']
    sheet = wb.active
    i = 1
    while i < a:
        ws.cell(i + 1, n).value = b[i]
        i = i + 1
    wbtest.save('E:\\PythonProgram\\test1.xlsx')# 保存關(guān)閉

# 寫入jp_bci_valid2021
copy_and_stick(1,3)
# copy_and_stick(2,5)

# 重新讀取，寫入列名

wbtest1 = load_workbook('E:\\PythonProgram\\test1.xlsx')
sheet = wbtest1.active

ws = wbtest1['Sheet1']

col = ["fd_objectid",       "pavementtype",	    "vehiclelane",   "roadcode",        "upanddown",
       "acquisitiondate",   "years",  	        "num",           "roadstart",       "roadends",
       "province_code",     "city_code",        "county_code",   "town_code"]

j = 1
for i in col:
    sheet.cell(row=1, column=j, value=i)
    j = j + 1

savepath = 'E:\\PythonProgram\\test1.xlsx'
wbtest1.save(savepath)

這種方法采用函數(shù)的形式來對(duì)表格進(jìn)行復(fù)制粘貼工作，讀取表格m列，粘貼到另一表格第n列，注意在調(diào)用一些方法是會(huì)調(diào)用Anaconda庫內(nèi)容，記得配置好，不然前幾行會(huì)報(bào)錯(cuò)。

from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.writer.excel import ExcelWriter
import xlrd

# 待處理表格路徑
wb = load_workbook (r"E:\PythonProgram\道網(wǎng)級(jí)數(shù)據(jù).xlsx")
# 表單名稱
ws = wb['網(wǎng)級(jí)數(shù)據(jù)排序（公式）']
sheet = wb.active
a = sheet.max_row
# 字段字典
dict_jp_bci_valid={'路面類型': 'pavementtype',   '路線代碼':'roadcode',       '起點(diǎn)樁號(hào)': 'roadstart',
                   '終點(diǎn)樁號(hào)': 'roadends',       '行政區(qū)劃':'deptcode',       '技術(shù)等級(jí)': 'grade',  
}
# 復(fù)制表格路徑
wbtest = load_workbook (r"E:\PythonProgram\tci_valid.xlsx")  #  修改*****
# 表單名稱
wss = wbtest['tci_valid']# 修改*****
sheet1 = wbtest.active
# 讀取列名
data = []
k = 0
for i in wbtest['tci_valid'][1]:  # 'Sheet1'為表單名稱, 1 為第一行修改*******
    data.insert(k,i.value)
    k += 1
d = []
e = 0
for z in wb['網(wǎng)級(jí)數(shù)據(jù)'][1]:  # 'Sheet1'為表單名稱, 1 為第一行
    d.insert(e,z.value)
    e += 1

i = 0
j = 1

for item in dict_jp_bci_valid.items():
    key = item[0]
    value1 = item[1]
    for codeindex in d:
        if key == codeindex:
            f = d.index(codeindex)
    hanzi = f + 1# 獲取表格對(duì)應(yīng)位置

    b = []
    while i < a:
        i = i + 1
        print(ws.cell(i,hanzi).value)
        b.insert(i, ws.cell (i,hanzi).value)# 寫入一列數(shù)據(jù)到b

    code = dict_jp_bci_valid[key]

    for cel in data:# 目標(biāo)列名
        if value1 == cel:
            c = data.index(cel) # 獲取目標(biāo)位置
    j = 1
    i = 1

    while j < a:
        wss.cell (j+1,c+1).value = b[i]# 粘貼到對(duì)應(yīng)位置
        j = j + 1
        i = i + 1
    b.clear()# 清空列表
    i = i - i# 行歸零
# 保存路徑
wbtest.save (r"E:\PythonProgram\Etci_valid.xlsx")# 修改*****

這種方法利用字典將列名進(jìn)行匹配，然后將相匹配的列內(nèi)容放進(jìn)去，前提是要先準(zhǔn)備好兩張表中的列名。