UnderTest
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Getting values from the excel file using Python
Hi, I have an excel file with parameters under two columns. Some cells contains no parameter (empty cells). If value under Column1 is empty, I need the value under Column2. I use: testParams = [] while myFile.IsEOF() != True: if myFile.Value["Column1"] != "": value = myFile.Value["Column1"] else: value = myFile.Value["Column2"] testParams.append(value) myFile.Next() But anyway I receive only the values under Column1: ["P1", "P2", None, None, None] I expect T3, T4, T5 etc instead off None.Solved1.5KViews0likes2Comments