import scipy.io as sio
import os
import xlwt
import xlrd
#dicom_name_file='ResultAnalysis.txt'
os.remove('ResultAnalysis.xls')
filename = xlwt.Workbook()
sheet = filename.add_sheet("Result")
sec_col=sheet.col(1)
sec_col.width=256*30
mat_predict=sio.loadmat('predictions_test.mat')
mat_contents=sio.loadmat('test_y.mat')
y_test=mat_contents['test_y']
#fileRest = open(dicom_name_file, 'a')
i = 0
for line in open(r"TestImg.txt"):
line = line[:-2]
nameIndex = line.index('r')
nlen = len(line)
sheet.write(i, 0, i)
sheet.write(i, 1, line[nameIndex:nlen - 8])
sheet.write(i, 2, line[nlen - 8:])
temp = mat_predict['arr'][i]
sheet.write(i,3,str(temp))
#fileRest.write(cc)
#fileRest.write('\n')
i=i+1
open(r"TestImg.txt").close()
filename.save("ResultAnalysis.xls")
#fileRest.close()
print('the end')