python pandas 读取excel hash读取保存 获取excel单元格对应的坐标信息

def getInfoOfInputFile(input_file_path):
    global info
    info = []
    temp = {}
    getInfo = pd.read_excel(input_file_path, sheet_name="Sheet1", dtype=str, keep_default_na=False)

    columns = getInfo.columns.size  # 列
    rows = getInfo.iloc[:, 0].size  # 行

    for i in range(0, rows):
        temp['MAINFLOW'] = getInfo['MAINFLOW'][i]
        temp['SUBFLOW'] = getInfo['SUBFLOW'][i]
        temp['TESTSTUITE'] = getInfo['TESTSTUITE'][i]
        temp['SPEC'] = getInfo['SPEC'][i]
        temp['TESTMOTHED'] = getInfo['TESTMOTHED'][i]
        temp['PARA'] = ''
        for j in range(5, columns):  # parameters start from column 6
            if(getInfo.iat[i, j] == ''):
                pass
            else:
                temp['PARA'] += ((getInfo.iat[i, j])+'\n\t\t\000')
        print(temp['PARA'])
        info.append(copy.deepcopy(temp))
    # return info