python 追加写入excel的多个sheet
import openpyxldef writeExcel(path, value, sheet):''':param sheet:sheet的名称:param path:文件的名字和路径:param value1: 写入的数据:return:'''book = openpyxl.Workbook()sheet1 = book.activesheet1.title = sheetfor i in range(0, len(value)):for j in range(0, len(value[i])):sheet1.cell(row=i + 1, column=j + 1, value=str(value[i][j]))book.save(path)print("写入数据成功！")def addExcel(path, value, sheet):''':param sheet:sheet的名称:param path:写入excel的路径:param value: 追加的数据:return:'''wb = openpyxl.load_workbook(path)wb.create_sheet(sheet)ws = wb[sheet]for ss in value:ws.append(ss)wb.save(path)print("写入成功")def main():value1 = [["标题1", "标题2", "标题3"],["a", "b", "c"],["1", "2", "3"]]writeExcel("sss.xlsx", value1,sheet="sheet1")path = "sss.xlsx"value2 = [["a", "b", "v"], ["ss", "bbb", "vvv"]]addExcel(path, value2, sheet="sheet2")if __name__ == '__main__':main()
