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
python pandas 读取excel hash读取保存 获取excel单元格对应的坐标信息
最新推荐文章于 2024-08-05 12:42:38 发布