def fillNaG(x):
for i,v in x.items():
if v=='':
x[i]='-'
return x
def test12():
INPUTFILE1 = os.path.join(BASE_PATH, 'Students6.xlsx')
datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0)
for sheetname,sheetdatas in datas.items():
sheetdatas=sheetdatas.apply(fillNaG,axis=1)
OUTPUTFILE1 = os.path.join(BASE_PATH, 'resultTemp.xlsx')
ExcelUntil.writeExcelFile(OUTPUTFILE1, datas, headerRow=1, indexFlag=True)