现在只能输出最后一组数据,改了大半天了,作为new hand,实在想不出来了,怎么才能使输入的数据多一点哇😭
因为你输入的数据没有保存在列表里呀,而且你保存excel的代码也放在循环里了,所以就相当于一次次都被覆盖掉了,而且循环一次,excel文件就被关了。
试试这样改:
import xlsxwriter
workbook = xlsxwriter.Workbook('health4.xlsx')
worksheet = workbook.add_worksheet()
headings=['high','weigh','BMI']
temp = input('请输入一组身高h:')
h = float(temp)
temp1 = input('请输入一组体重w:')
w = float(temp1)
i = [h]
j = [w]
k = [h/(w*w)]
while h!=2.0:
temp = input('请输入一组身高h:')
h = float(temp)
temp1 = input('请输入一组体重w:')
w = float(temp1)
i.append(h)
j.append(w)
k.append(h/(w*w))
data = [i, j, k]
worksheet.write_row('A1',headings)
worksheet.write_column('A2', data[0])
worksheet.write_column('B2', data[1])
worksheet.write_column('C2', data[2])
workbook.close()