# coding:utf8
import xlwt
from openpyxl import Workbook
def write_excel_xlsx(path, sheet_name_lt, value_list):
if len(sheet_name_lt) != len(value_list): # 判断表格数量和写入数据是否一致
print(u'表格数量和数据长度不一致')
return
workbook = xlwt.Workbook() # 新建一个工作簿
for num in range(len(sheet_name_lt)):
sheet_name = sheet_name_lt[num]
value = value_list[num]
index = len(value) # 获取需要写入数据的行数
sheet = workbook.add_sheet(sheet_name) # 在工作簿中新建一个表格
for i in range(0, index):
for j in range(0, len(value[i])):
sheet.write(i, j, value[i][j]) # 像表格中写入数据(对应的行和列)
workbook.save(path) # 保存工作簿
print("xls格式表格写入数据成功!")
if __name__ == '__main__':
value_lt = [
[[1, 2, 3, 4], [5, 6, 7, 8]],
[['a', 'b', 'c', 'd'], ['e', 'f', 'i', 'g']],
]
write_excel_xlsx(u'测试.xlsx', ['sheet1', 'sheet2'], value_lt)
用朋友碰到了编码问题:
workbook = xlwt.Workbook() # 改成
workbook = xlwt.Workbook(encoding='utf-8') # 可以试试