user4.py

import pandas as pd
import os
import PyInstaller.__main__

def generate_user_exe(input_name):
    excel_file = "C:\\Users\\user\\OneDrive\\Desktop\\SAINS\\Week 4\\7.8.2023\\UserList.xlsx"

    try:
        # Read the Excel file into a pandas DataFrame
        df = pd.read_excel(excel_file)

        # Check if the required columns exist in the DataFrame
        required_columns = ['Username', 'Password', 'Email']
        missing_columns = [col for col in required_columns if col not in df.columns]
        if missing_columns:
            print(f"Error: Required columns not found in Excel file: {', '.join(missing_columns)}")
            return

        # Create a directory to store the .exe files
        output_dir = os.path.join(os.getcwd(), "user_exe_files")
        os.makedirs(output_dir, exist_ok=True)

        for username in df['Username'].unique():
            # Filter the DataFrame for the current username
            filtered_df = df[df['Username'] == username]

            # Retrieve the Username, Password, and Email for the user
            username = filtered_df['Username'].iloc[0]
            password = filtered_df['Password'].iloc[0]
            email = filtered_df['Email'].iloc[0]

            # Prepare the content for the .py file (Python script)
            script_content = f"""
username = "{username}"
password = "{password}"
email = "{email}"

print("Username:", username)
print("Password:", password)
print("Email:", email)
"""

            # Create a temporary .py file
            temp_py_file = f"{username}_details.py"
            with open(temp_py_file, "w") as file:
                file.write(script_content)

            # Use PyInstaller to convert the temporary .py file to .exe
            PyInstaller.__main__.run([
                '--onefile',
                '--distpath',
                output_dir,
                temp_py_file
            ])

            # Clean up the temporary .py file
            os.remove(temp_py_file)

            print(f"{username}.exe generated with user details.")

    except FileNotFoundError:
        print("Excel file not found.")
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    generate_user_exe(None)