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()

logout from linux ssh from windows powershell

 To exit the Bash session, type "exit" without quotes and then the Enter key.

That should exit the SSH session and get you back to the PS C:\Windows\system32 prompt.

Just close the Powershell session by clicking on the X at the upper right corner of the window.

bash: apt-get: command not found CentOS 7

  Amazon Linux it's CentOS-based, which is RedHat-based. RH-based installs use yum not apt-get. Something like yum search httpd should show you the available Apache packages - you likely want yum install httpd24.