如何在openpyxl python中检查单元格是否为空

问题描述：

我正在openpyxl Python中执行条件语句，以检查单元格是否为空.这是我的代码:

I'm making a conditional statement in openpyxl Python to check if a cell is empty. Here's my code:

newlist = []
looprow = 1
print ("Highest col",readex.get_highest_column())
getnewhighcolumn = readex.get_highest_column()        
for i in range(0, lengthofdict):
    prevsymbol = readex.cell(row = looprow,column=getnewhighcolumn).value
    if prevsymbol == "None":
        pass
    else:
        newstocks.append(prevsymbol)
        looprow += 1
    #print (prevsymbol)
print(newlist)

我尝试if prevsymbol == "":和if prevsymbol == null:无济于事.

答

您将prevsymbol与str无"而不是None对象进行比较.试试

You compare prevsymbol with str "None", not None object. Try

if prevsymbol == None:

也在这里

prevsymbol = readex.cell(row = looprow,column=getnewhighcolumn).value

您将looprow用作行索引.并且仅当cell.value不为空时，才递增looprow.在这里

you use looprow as row index. And you increment looprow only if cell.value is not empty. Here

newstocks.append(prevsymbol)

您使用newstocks而不是newlist.试试这个代码

you use newstocks instead of newlist. Try this code

newlist = []
print ("Highest col",readex.get_highest_column())
getnewhighcolumn = readex.get_highest_column()        
for i in range(0, lengthofdict):
    prevsymbol = readex.cell(row = i+1,column=getnewhighcolumn).value
    if prevsymbol is not None:
        newlist.append(prevsymbol)
print(newlist)

如何在openpyxl python中检查单元格是否为空

相关推荐