def getInfoOfInputFile(input_file_path):
global info
info = []
temp = {}
getInfo = pd.read_excel(os.path.join(os.getcwd()+'\\input', input_file_path), sheet_name="frequency_plan", 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'])
print("*******************************")
info.append(copy.deepcopy(temp))
# return info
Read More:
- Copy the python3 installation package to Linux and run it. Error while loading shared libraries: libpython3.6. M.so. 1.0
- The automatic token of Python interface is passed into the header
- Python + Requests +Excel+Jenkins interface automation
- How to Solve Opencv Reads Video Error: cv2.error
- Zlib.error: error – 3 while decompressing: incorrect header check in Python
- Pychar can’t connect to Python console, but it can run. Py file, and Anaconda’s command line can run Python command
- Python openpyxl excel open zipfile error resolution: zipfile.BadZipFile: File is not a zip file
- [Solved] NPM install Error: check python checking for Python executable python2 in the PATH
- An introduction to sys modules in Python and how packages are imported and used
- [Solved] Selenium python send_key error: list object has no attribute
- Python3 Error: Cannot uninstall ‘numpy’. It is a distutils installed project and thus we cannot accurate
- python2.7 ExcelWriter error Exception caught in workbook destructor. Explicit close() may be require
- Python recursively traverses all files in the directory to find the specified file
- How to Fix keyerror in Python dictionary lookup
- [Solved] RuntimeError: “unfolded2d_copy“ not implemented for ‘Half‘
- Pyexcel Error: xlrd.biffh.XLRDError: Excel xlsx file; not supported
- Python: How to Solve multiprocessing module Error in Windows
- Python: How to Reshape the data in Pandas DataFrame
- Python: How to parses HTML, extracts data, and generates word documents