問題描述

有數(shù)據(jù)data： [(1,),(2,),(3,)],[(’a’,),(’b’,),(’c’,)],[(’e’,),(’f’,),(’g’,)]分別代表三種不同的列的值。需求是：橫向?qū)懭氡砀裼涗洠?img alt='python - xlwt橫向插入表格數(shù)據(jù)' src='http://www.lshqa.cn/attached/image/news/202210/1320397e3e.png'>

我的程序如下，只能實(shí)現(xiàn)數(shù)列插入，不知道更改如何修改插入的順序，求指導(dǎo)。

import xlwtwb = xlwt.Workbook(encoding=’utf-8’)ws = wb.add_sheet(’Sheet1’, cell_overwrite_ok=True)data = ([(1,),(2,),(3,)],[(’a’,),(’b’,),(’c’,)],[(’e’,),(’f’,),(’g’,)],)for index, value in enumerate(data): for r_num, r_value in enumerate(value):ws.write(r_num, index,r_value[0])wb.save(’test.xls’)

問題解答

ws.write(index, r_num,r_value)

import xlwtwb = xlwt.Workbook(encoding=’utf-8’)ws = wb.add_sheet(’Sheet1’, cell_overwrite_ok=True)data_old = ([(1,),(2,),(3,)],[(’a’,),(’b’,),(’c’,)],[(’e’,),(’f’,),(’g’,)],)data = [i for i in map(list,zip(*data_old))]col = len(data)row = len(data[0])for r_row in range(row): for r_col in range(col):ws.write(r_row,r_col,data[r_row][r_col][0])wb.save(’test.xls’)