python 实现在Excel末尾增加新行
时间:2021-04-08 10:38:11|栏目:Python代码|点击: 次
实例如下所:
import os import xlrd import xlwt from xlutils.copy import copy def excelwrite(L=None): if L is None: L = [] print(L) filename = r'wldata.xls' workbook = xlrd.open_workbook(filename, formatting_info=True) sheet = workbook.sheet_by_index(0) rowNum = sheet.nrows colNum = sheet.ncols newbook = copy(workbook) newsheet = newbook.get_sheet(0) # 在末尾增加新行 str = 'hehe' newsheet.write(rowNum, 0, str) # 覆盖保存 newbook.save(filename)
栏 目:Python代码
本文地址:http://www.codeinn.net/misctech/96883.html






