1 基于openpyxl.Workbook
from openpyxl import Workbook # 向sheet中写入一行数据 def insertOne(value, sheet): row = [value] * 3 sheet.append(row) # 新建excel,并创建多个sheet if __name__ == "__main__": book = Workbook() # 新建2个自定义的sheet for i in range(0, 2): # 为每个sheet设置title,插入位置index sheet = book.create_sheet("sheet" + str(i + 1), i) # 每个sheet里设置列标题 sheet.append(["title" + str(i + 1)] * 3) sheets = book.get_sheet_names() count = 0 # 向sheet中插入数据 for i in range(0, 10): insertOne("ni", book.get_sheet_by_name(sheets[1])) insertOne("wo", book.get_sheet_by_name(sheets[0])) insertOne("ta", book.get_sheet_by_name(sheets[1])) count = count + 1 # 保存数据到.xlsx文件 book.save("test.xlsx") print(str(count))