2021-09-09

原创于 2021-09-09 23:24:41 发布 · 133 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python

python 专栏收录该内容

3 篇文章

订阅专栏

这段代码展示了如何使用Python的openpyxl和xlrd库来插入Excel表格的头部和尾部。`inserthead`函数在工作表的第一列插入一列，并在头部设置'HEAD'值。`insertend`函数在最后一列追加'append'值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#coding=utf-8
import xlrd

from openpyxl import load_workbook
import xlutils.copy
# sheet = workbook.active
# sheet.insert_cols(idx=1,amount=1)
def inserthead(filename="C:\\Users\\Administrator\\Desktop\\123.xlsx"):
    workbook = load_workbook(filename)
    ws = workbook. worksheets[0]

    ws.insert_cols(0)
    for index ,row in enumerate(ws.rows):
        if index ==0:
            row[0].value = "HEAD"
        else:
            row[0].value = index
    workbook.save("C:\\Users\\Administrator\\Desktop\\123.xlsx")



def insertend(filename="C:\\Users\\Administrator\\Desktop\\123.xlsx"):
    workbook = load_workbook(filename)
    wk = workbook.worksheets[0]
    coulumn = wk.max_column
    data = xlrd.open_workbook(filename)
    ws = xlutils.copy.copy(data)
    table = ws.get_sheet(0)

    table.write(0,coulumn,'append')

    ws.save("C:\\Users\\Administrator\\Desktop\\123.xlsx")
inserthead()
insertend()