python code to import xlsx file in mysql and validate also each column and rows before import

 import mysql.connector

import openpyxl

# Open the .xlsx file

wb = openpyxl.load_workbook('data.xlsx')

sheet = wb.active

# Connect to the MySQL database

cnx = mysql.connector.connect(user='user', password='password', host='host', database='database')

cursor = cnx.cursor()

# Validate and import the data

for row in sheet.rows:

    # Validate each cell in the row

    if row[0].value == None:

        print("Error: Missing value in column 1")

    elif row[1].value == None:

        print("Error: Missing value in column 2")

    else:

        # If the data is valid, insert it into the database

        sql = "INSERT INTO table (column1, column2) VALUES (%s, %s)"

        val = (row[0].value, row[1].value)

        cursor.execute(sql, val)

# Commit the changes to the database

cnx.commit()

# Close the connection

cnx.close()