使用python将列从一个excel文件复制到另一个excel文件工作表。

import openpyxl

source_file = openpyxl.load_workbook('source.xlsx')
target_file = openpyxl.load_workbook('target.xlsx')

source_sheet = source_file['Sheet1']
target_sheet = target_file['Sheet1']

column_data = []
for cell in source_sheet['A']:
    column_data.append(cell.value)

for i, value in enumerate(column_data):
    target_sheet.cell(row=i+1, column=1).value = value

target_file.save('target.xlsx')

import openpyxl

source_file = openpyxl.load_workbook('source.xlsx')
target_file = openpyxl.load_workbook('target.xlsx')

source_sheet = source_file['Sheet1']
target_sheet = target_file['Sheet1']

column_data = []
for cell in source_sheet['A']:
    column_data.append(cell.value)

for i, value in enumerate(column_data):
    target_sheet.cell(row=i+1, column=1).value = value

target_file.save('target.xlsx')