import xlwt
def write_xls_sheet(path, sheet_name, value):
workbook = global_workbook
sheet = workbook.add_sheet(sheet_name)
for i in range(len(value)):
for j in range(len(value[i])):
sheet.write(i, j, value[i][j])
workbook.save(path)
if __name__ == "__main__":
global_workbook = xlwt.Workbook()
write_xls_sheet("./data/test.xls", "a", [[1, 2, 3], [4, 5, 6]])
write_xls_sheet("./data/test.xls", "b", [["name", "age", ["weight", "high"]]])
猜你喜欢:👇🏻
⭐【Python】with open 打开文件的不同方式
⭐【Python】格式化print输出,描述在前,变量在后
⭐【Python】find()函数居然还能指定搜索的起点和终点?