I want to filter using openpyxl.

Country Flag      
America OK
Japan   
Argentina OK
Brazil  

I would like to specify a column like pandas and filter it just before.

# remove the filter from OK
 df=df[df["Flag"]!="OK"]
 # print(df)

Alternatively, select column B blank

# Select only spaces
  df = df [df['Flag'].isnull()]

Country Flag      
Japan   
Brazil  

Country Flag      
America OK
Japan OK
Argentina OK
Brazil OK

import openpyxl 
import time
from selenium import webdriver
from webdriver_manager.chrome import ChromeDriverManager
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.chrome.options import Options
from selenium.common.exceptions import NoSuchElementException

# Excel loading
file_excel_r=r "C:\Users\test\Documents\test.xlsx"

# Load Excel file
wb=openpyxl.load_workbook(file_excel_r)
ws = wb ["Sheet1" ]

# Read line by line
# loop from line 2
for i in range(2,ws.max_row+1):
 
 options=Options()
 options.add_argument('--headless') 
 options.add_argument('--no-sandbox')
 options.add_argument('--disable-gpu')
     
 driver=webdriver.Chrome(executable_path=ChromeDriverManager().install())

 #country
 country=ws['a'+str(i)].value

 #flag
 flag = ws ['b'+str(i)].value

 # url specification
 url="https://www.google.com/search?q="+country
 print(url)
 
 # open a search site
 driver.get(url)
 
 # Wait 2 seconds
 time.sleep(2)

 # Write OK if column B is blank
 if flag is None or not str(flag).strip():
        ws ['B'+str(i)].value="OK"
 else:
       print('No Blank')

 # Save Excel
 wb.save(file_excel_r)

 driver.quit()