def main(path):
try:
df = pd.read_excel(path,
sheet_name=pL.testSheetName,
encoding="cp932",
header=1)
except:
errorMsg = "データが読み込めませんでした。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
return (errorMsg)
errorMsg = getErrorMsg(df)
if errorMsg == False:
try:
diagnosticEngineering(df, path)
_utils.createErrorCheckFile(path, program=program)
except:
errorMsg = "予期せぬエラーが発生しました。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
return (errorMsg)
def main(path):
try:
df = pd.read_excel(path,
sheet_name=pL.patientSheetName,
header=1,
encodeing="cp932")
except:
errorMsg = "データが読み込めませんでした。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
return (errorMsg)
errorMsg = getErrorMsg(df)
if errorMsg == False:
try:
conversion(df, path)
formatExcelStyle(path)
_utils.createErrorCheckFile(path, program=program)
except:
errorMsg = "予期せぬエラーが発生しました。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
print(errorMsg)
return (errorMsg)
def main(path1, path2):
try:
df = pd.read_excel(path1,
sheet_name=pL.patientSheetName,
header=1,
encodeing="cp932")
hospital = pd.read_excel(path2, encoding='cp932', sheet_name='Sheet1')
except:
errorMsg = "データが読み込めませんでした。\n"
import traceback
errorMsg += traceback.format_exc()
return (errorMsg)
errorMsg = getErrorMsg(df, hospital)
if errorMsg == False:
try:
mergeProcessFiles(df, hospital)
#formatExcelStyle()
_utils.createErrorCheckFile(path1, program=program)
_utils.createErrorCheckFile(path2, program=program)
except:
errorMsg = "予期せぬエラーが発生しました。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
return (errorMsg)
def main(path):
try:
df = pd.read_excel(path, header = 1,
sheet_name = pL.patientSheetName,
encoding="cp932")
dataProcessing(df,path)
_utils.createErrorCheckFile(path,program = program)
except:
return("読み取りエラーです")
return(False)
def main(path1, path2):
df = pd.read_excel(path1,
sheet_name=pL.patientSheetName,
encoding="cp932",
header=1)
test = pd.read_excel(path2,
header=1,
encodeing="cp932",
sheet_name="Sheet1")
mergeTest(df, test, path1)
_utils.createErrorCheckFile(path1, program=program)
_utils.createErrorCheckFile(path2, program=program)
return (False)
def runProgram(self):
self.statusLbl.setText("実行中")
self.statusLbl.repaint()
QTest.qWait(0.5)
self.errorMsg = ""
# プログラムごとの対応
if self.fileFlag:
try:
callRunProgram = lambda x: self.Items[x].get(
"run", self.runErorr)()
callRunProgram(self.combo.currentText())
for f in [
self.fileName, self.fileName1, self.fileName2,
self.fileName3
]:
if f:
_utils.createErrorCheckFile(
f, program=self.combo.currentText())
except:
dir_ = _utils.getOutputDir()
fileErrorRecord = "errorRecord.txt"
pathErorrRecord = dir_ + fileErrorRecord
self.errorMsg += "予期せぬエラーが発生しました。\n"
self.errorMsg += f"{fileErrorRecord} にエラーを出力してます。"
with open(pathErorrRecord, "w") as f:
import traceback
errorRecord = traceback.format_exc()
f.write(errorRecord)
else:
self.errorMsg += ".xlsxのファイルを選択してから実行してください。"
self.runErrorCheck(self.errorMsg)
self.statusLbl.repaint()
def main(path):
try:
df1 = pd.read_excel(path,
header=1,
encodeing="cp932",
Sheet_name=pL.patientSheetName)
except:
errorMsg = "データが読み込めませんでした。\n"
import traceback
errorMsg += traceback.format_exc()
return (errorMsg)
errorMsg = getErrorMsg(df1)
if errorMsg == False:
try:
tableProcessing(df1, path)
_utils.createErrorCheckFile(path, program=program)
except:
errorMsg = "予期せぬエラーが発生しました。\n"
import traceback
errorMsg += traceback.format_exc()
print(errorMsg)
return (errorMsg)
def runItemAll(self):
# read files
try:
df, pullDown, test, hospital = self.readFiles()
_utils.createErrorCheckFile(self.fileName1, program="全実行")
_utils.createErrorCheckFile(self.fileName2, program="全実行")
_utils.createErrorCheckFile(self.fileName3, program="全実行")
except:
errorMsg = "予期せぬエラーが発生しました\n"
import traceback
errorMsg += traceback.format_exc()
self.runErrorCheck(errorMsg)
return ()
# run program one by one.
#import test_totaling
#test_totaling.diagnosticEngineering(test,self.fileName2)
import merge_test_result
merge_test_result.mergeTest(df, test, self.fileName1)
dir_ = _utils.getOutputDir()
pathNew = dir_ + self.fileName1.split("/")[-1][:-5] + "_rep.xlsx"
dfNew = pd.read_excel(pathNew,
sheet_name=pL.patientSheetName,
encoding="cp932",
header=1)
import patient_basic_info
patient_basic_info.diagnosticEngineering(dfNew, pullDown, pathNew)
import in_hosp_status
in_hosp_status.mergeProcessFiles(dfNew, hospital)
in_hosp_status.formatExcelStyle()
import simple_in_hosp_status
simple_in_hosp_status.conversion(dfNew, pathNew)
simple_in_hosp_status.formatExcelStyle(pathNew)
import patient_info_totaling
patient_info_totaling.tableProcessing(dfNew, pathNew)
import patient_daily_totaling
patient_daily_totaling.tableProcessing(dfNew, pathNew)
import output_A4_format
output_A4_format.dataProcessing(dfNew, pathNew)
