import xlwt import pandas as pd
path = '/Users/xxx/Desktop/综合评估分析/BRIC-ACS/测试专用表格.xls' data = pd.DataFrame(pd.read_excel(path)) data1 = data['受试者编号'] data2 = data['性别'] data3 = data['年龄'] value = pd.concat([data1,data2,data3],axis=1) #print(value)
def write_excel_xls(path1,sheet_name,value): index = len(value) workbook = xlwt.Workbook() 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('/Users/xxx/Desktop/测试输出整理.xls') print("xls格式表格写入数据成功！")
