Chapter 6: Automating Desktop Applications

pip install pyautogui
pip install pywinauto
pip install selenium
pip install pandas
pip install openpyxl

print("PDTC Desktop Automation Setup Successful")

import pyautogui
import time

# Wait 3 seconds so you can move your hand away from the mouse.
time.sleep(3)

# Move mouse to x=500, y=300 position on screen.
pyautogui.moveTo(500, 300, duration=1)

# Click at the current mouse position.
pyautogui.click()

print("Mouse moved and clicked successfully.")

import pyautogui
import time

time.sleep(3)

pyautogui.write("Welcome to PDTC Desktop Automation Training", interval=0.05)

print("Text typed successfully.")

import pyautogui
import time

print("Move your mouse. Press Ctrl + C to stop.")

while True:
    x, y = pyautogui.position()
    print("Mouse Position:", x, y)
    time.sleep(1)

import pyautogui
import time
import os

# Open the Windows Run dialog.
pyautogui.hotkey("win", "r")
time.sleep(1)

# Type notepad and press Enter.
pyautogui.write("notepad")
pyautogui.press("enter")
time.sleep(2)

# Type content into Notepad.
message = """PDTC Desktop Automation Example

This file was created automatically using Python and PyAutoGUI.

Learning Outcome:
Develop desktop automation solutions.
"""

pyautogui.write(message, interval=0.01)

# Save file using Ctrl + S.
pyautogui.hotkey("ctrl", "s")
time.sleep(1)

# Prepare file path.
desktop = os.path.join(os.path.expanduser("~"), "Desktop")
file_path = os.path.join(desktop, "PDTC_Automation_Test.txt")

# Type file path in Save As dialog.
pyautogui.write(file_path)
pyautogui.press("enter")

print("Notepad file created successfully:", file_path)

import pyautogui
import os
from datetime import datetime

desktop = os.path.join(os.path.expanduser("~"), "Desktop")

timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")

file_name = "PDTC_Screenshot_" + timestamp + ".png"

file_path = os.path.join(desktop, file_name)

screenshot = pyautogui.screenshot()

screenshot.save(file_path)

print("Screenshot saved:", file_path)

import pandas as pd

# Create sample transaction data.
data = {
    "Department": ["Finance", "HR", "Finance", "Training", "Training", "HR"],
    "Task": ["Invoice", "Payroll", "Report", "Attendance", "Certificate", "Onboarding"],
    "Minutes_Saved": [120, 90, 60, 45, 75, 80]
}

# Convert dictionary into DataFrame.
df = pd.DataFrame(data)

# Group data by department and calculate total minutes saved.
summary = df.groupby("Department")["Minutes_Saved"].sum().reset_index()

# Save original and summary report.
df.to_csv("pdtc_automation_tasks.csv", index=False)
summary.to_csv("pdtc_automation_summary.csv", index=False)

print("Original Data:")
print(df)

print("\nSummary Report:")
print(summary)

print("\nCSV reports created successfully.")

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill

# Create workbook and worksheet.
wb = Workbook()
ws = wb.active
ws.title = "Automation Savings"

# Add header row.
headers = ["Department", "Process", "Minutes Saved"]
ws.append(headers)

# Add data rows.
rows = [
    ["Finance", "Invoice Processing", 120],
    ["HR", "Payroll Support", 90],
    ["Training", "Attendance Report", 45],
    ["Training", "Certificate Generation", 75]
]

for row in rows:
    ws.append(row)

# Format header.
for cell in ws[1]:
    cell.font = Font(bold=True)
    cell.fill = PatternFill(start_color="FFD400", end_color="FFD400", fill_type="solid")

# Save workbook.
wb.save("PDTC_Automation_Savings.xlsx")

print("Excel report created successfully.")

from pywinauto.application import Application
import time

# Start Notepad application.
app = Application(backend="uia").start("notepad.exe")

# Wait for Notepad to open.
time.sleep(2)

# Connect to Notepad window.
window = app.window(title_re=".*Notepad.*")

# Type text inside Notepad.
window.type_keys("PDTC Pywinauto Desktop Automation Example", with_spaces=True)

print("Text typed in Notepad using pywinauto.")

from pywinauto.application import Application
import time
import pyautogui

# Start Windows Calculator.
app = Application(backend="uia").start("calc.exe")

# Wait for calculator to open.
time.sleep(2)

# Use keyboard input to calculate 25 + 17.
pyautogui.write("25")
pyautogui.press("+")
pyautogui.write("17")
pyautogui.press("enter")

print("Calculator automation completed.")

pip install selenium

from selenium import webdriver
from selenium.webdriver.chrome.options import Options

# Create Chrome browser options.
options = Options()

# Open browser.
driver = webdriver.Chrome(options=options)

# Go to PDTC website.
driver.get("https://perakskills.com")

# Print page title.
print("Page Title:", driver.title)

# Close browser.
driver.quit()

<!DOCTYPE html>
<html>
<head>
<title>PDTC Test Form</title>
</head>
<body>

<h1>PDTC Automation Test Form</h1>

<label>Name</label>
<input id="name" type="text">

<br><br>

<label>Course</label>
<input id="course" type="text">

<br><br>

<button id="submitBtn" onclick="showResult()">Submit</button>

<p id="result"></p>

<script>
function showResult(){
  let name = document.getElementById("name").value;
  let course = document.getElementById("course").value;
  document.getElementById("result").innerHTML =
  "Submitted: " + name + " - " + course;
}
</script>

</body>
</html>

from selenium import webdriver
from selenium.webdriver.common.by import By
from pathlib import Path
import time

# Get full file path of local HTML form.
file_path = Path("test_form.html").resolve()

# Open Chrome browser.
driver = webdriver.Chrome()

# Open local HTML file.
driver.get(file_path.as_uri())

# Fill name field.
driver.find_element(By.ID, "name").send_keys("PDTC Student")

# Fill course field.
driver.find_element(By.ID, "course").send_keys("Certified Industrial Automation Professional")

# Click submit button.
driver.find_element(By.ID, "submitBtn").click()

# Wait so user can see result.
time.sleep(3)

# Print result text.
result = driver.find_element(By.ID, "result").text
print(result)

# Close browser.
driver.quit()

import pyautogui
import time

try:
    time.sleep(2)

    # Try to press Ctrl + S.
    pyautogui.hotkey("ctrl", "s")

    print("Save shortcut executed successfully.")

except Exception as error:
    print("Automation error occurred:", error)

from datetime import datetime

try:
    result = 10 / 0

except Exception as error:
    with open("automation_error_log.txt", "a") as log:
        log.write(str(datetime.now()) + " - " + str(error) + "\n")

    print("Error logged successfully.")