Python implements adding new rows at the end of Excel

This article mainly introduces the implementation of adding new rows at the end of Excel in python, which has certain reference value. Now I share it with you. Friends in need can refer to the

example As follows:

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)

Related recommendations:

Search based on file name implemented in Python Data file function example

The above is the detailed content of Python implements adding new rows at the end of Excel. For more information, please follow other related articles on the PHP Chinese website!