#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()
2021-09-09
最新推荐文章于 2024-07-08 00:01:13 发布