jira_report

extract_columns.py

import pandas as pd

df = pd.read_excel(
    "input.xlsx",
    engine="openpyxl",
    sheet_name="Sheet1",
    skiprows=3,
)

list = [
    "Project",
    "Key",
    "Summary",
    "Issue Type",
    "Status",
    "Priority",
    "Resolution",
    "Assignee",
    "Reporter",
    "Creator",
    "Created",
    "Due Date",
]

list = [x.strip() for x in list]
df = df[list]
df = df.dropna(how="all")

df.to_excel("output.xlsx", index=False)