利用Python将数据写入xlsx文件

导入openpyxl

可用pip下载该包

pip install openpyxl

数据写入xlsx

建立Workbook的语句

workbook = openpyxl.Workbook()
sheet = workbook.active
sheet.title = "sheet"

在表格的第row行第col列写入value
（row，col >= 1）

sheet.cell(row, col, value)

保存信息的语句

workbook.save(filename="table.xlsx")

实际应用

import openpyxl


if __name__ == '__main__':
    table = ["customer", "lineitem", "nation", "orders", 
    		"part", "partsupp", "region", "supplier"]
    
	workbook = openpyxl.Workbook()
    sheet = workbook.active
    sheet.title = "sheet"
    row = 1
    # 效果是在的第一行
    for i in range(len(table)):
        sheet.cell(row, i+1, table[i])
    workbook.save(filename="table.xlsx")