Excel Automation using Python in Tamil | Step by Step openpyxl

Excel Sheet (marks.xlsx)

A1 → Name     B1 → Marks     C1 → Result
A2 → Arun     B2 → 85        C2 → 
A3 → Kavi     B3 → 40        C3 → 
from openpyxl import load_workbook

wb = load_workbook("marks.xlsx")
sheet = wb.active

marks = sheet["B2"].value

if marks >= 50:
    sheet["C2"] = "PASS"
else:
    sheet["C2"] = "FAIL"

wb.save("marks.xlsx")


Read Column → Update Another Column (Same Sheet)

for r in range(2, sheet.max_row + 1):
    marks = sheet[f"B{r}"].value

    if marks >= 50:
        sheet[f"C{r}"] = "PASS"
    else:
        sheet[f"C{r}"] = "FAIL"

wb.save("marks_updated.xlsx")

Read from Sheet1 → Update Sheet2

Sheet1: Data

Name | Marks
Arun | 85
Kavi | 40

Sheet2 : Result

Name | Result

data_sheet = wb["Data"]
result_sheet = wb["Result"]

for r in range(2, data_sheet.max_row + 1):
    name = data_sheet[f"A{r}"].value
    marks = data_sheet[f"B{r}"].value
    if marks >= 50:
        result = "PASS"
    else:
        result = "FAIL"
    result_sheet.append([name, result])

wb.save("result_sheet.xlsx")