Getting None when printing RunMode from testcases sheet | Selenium Python Forum
N
Nitika Sharma Posted on 10/12/2020

I have made isRunnable funtion but getting None when trying to call it

Please check the attached zip


J
Jaspreet Replied on 10/12/2020

Hey, 

The error is in readingData.py in getCellDataByColName().

    def getCellDataByColName(self,sheetName,rowIndex,colName):
        sheetData=self.readXLS.sheet_by_name(sheetName)
        for cNum in range(0,sheetData.ncols):
            extractedColName=sheetData.cell_value(0,cNum)
            if colName==extractedColName:
                # cellData=sheetData.cell(rowIndex,cNum) we do not need the cell infor,ation just the value is required
                cellData = sheetData.cell_value(rowIndex, cNum)
                if cellData != '':
                    return cellData
                else:
                    return ''

Refer the snippet and correct your code.


N
Nitika Sharma Replied on 10/12/2020

Hello, thanks

Issue has been fixed


J
Jaspreet Replied on 10/12/2020

Thank you for the update.


Related Posts