Python Forum
NoneType allways a problem - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: NoneType allways a problem (/thread-8612.html)

NoneType allways a problem - mariolopes - Feb-28-2018

Hi
I got a problem
I use the following code to get the elements from one webpage. The problem is I can't save the value if the item is none
The problem exists when I write 

 ws['G'+str(i)] =  keywords['content']
Got the error:
Error:
Traceback (most recent call last):
  File "C:\Users\ASUS PC\AppData\Local\Programs\Python\Python36\getdescription.py", line 122, in <module>
    h= keywords['content']
TypeError: 'NoneType' object is not subscriptable
If the values are empty I want to write "Blank Value"

from openpyxl import load_workbook
wb2 = load_workbook('teste.xlsx')
ws=wb2.active
last_row = ws.max_row
print(last_row)
for i in range(1,last_row+1):
    al=ws['B'+str(i)]
    print(al.value)
    b=al.value
    if(b is not None and 'T' in b): #vai buscar o titulo
        print('Processando o link '+ws['A'+str(i)].value)
        titulo=buscaTitulo(ws['A'+str(i)].value)        
        ws['C'+str(i)] = titulo
    if(b is not None and 'D' in b): #vai buscar a descricao
        print('Processando o link '+ws['A'+str(i)].value)
        descricao=buscaDescricao(ws['A'+str(i)].value)                        
        ws['E'+str(i)] = descricao['content']
    if(b is not None and 'K' in b): #vai buscar a keyword
        print('Processando o link '+ws['A'+str(i)].value)
        keywords=buscaKeyword(ws['A'+str(i)].value)
        ws['G'+str(i)] =  keywords['content']                 
#ws['F5'] = "teste"
wb2.save('teste.xlsx')


RE: NoneType allways a problem - mariolopes - Mar-01-2018

Solved


...
 if keywords:
   u=keywords['content']
 else:
   u="Nada"