python 保存数据到excel

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))

 

转载于:https://www.cnblogs.com/mydesky2012/p/11506738.html