df_bodyEffect = df_norows_skipped['Output'] df_qrr = df_norows_skipped['QRR'] df_qg = df_norows_skipped['QG'] ## call sanityCheck functions from library sclib.read_ratings(df_ratings) sclib.read_electrical_specs(df_specs) sclib.read_package_impedance(df_impedance) sclib.transfer_sanityCheck(df_transfer) sclib.gdson_sanityCheck(df_gdson) sclib.bodyEffect_sanityCheck(df_bodyEffect) sclib.bodyDiode_sanityCheck(df_bodyDiode) sclib.cap_sanityCheck(df_cap) sclib.bvdss_sanityCheck(df_bvdss) sclib.idss_sanityCheck(df_idss) sclib.qrr_sanityCheck(df_qrr) sclib.qg_sanityCheck(df_qg) ## excel file merging at the ouput_files folder excel_files = Path(param_path).glob('*.xlsx') ## define the final excel name finalexcelName = targetexcelName.split('.')[0] # print(finalexcelName) # debug with xw.App(visible=False) as app: combined_wb = app.books.add() for excel_file in excel_files: wb = app.books.open(excel_file) for sheet in wb.sheets: sheet.copy(after=combined_wb.sheets[0])
excel_name = output_path / f'{inputName}_Calibration.xlsx' ## call sanityCheck functions from library sclib.transfer_output_correlation(df_rows_skipped, df_norows_skipped, inputName) sclib.read_ratings(df_ratings, excel_name) sclib.read_electrical_specs(df_specs, excel_name) sclib.read_package_impedance(df_impedance, excel_name) sclib.transfer_sanityCheck(df_transfer, df_ratings, inputName, excel_name) sclib.gdson_sanityCheck(df_gdson, inputName, excel_name) sclib.bodyEffect_sanityCheck(df_bodyEffect, inputName, excel_name) sclib.bodyDiode_sanityCheck(df_bodyDiode, inputName, excel_name) sclib.cap_sanityCheck(df_cap, inputName, excel_name) sclib.bvdss_sanityCheck(df_bvdss, inputName, excel_name) sclib.idss_sanityCheck(df_idss, inputName, excel_name) sclib.qrr_sanityCheck(df_qrr, inputName, excel_name) sclib.qg_sanityCheck(df_qg, inputName, excel_name) print('\nCreating mdms for ' f'{inputName}...') print('\nSanity check finished and mdm files created...') print('\nTotal elapsed time: %s seconds' % (time.time() - start_time)) except Exception as e: print(e.__class__, "occurred.") print(e)