Generate excel sheet

184 views
Skip to first unread message

Kiran Anilkumar

unread,
Jun 19, 2025, 2:53:55 AMJun 19
to openpyxl-users
i want this code to be worked and generate a detailed excel sheet.

import pandas as pd
from openpyxl import Workbook

# Create data for each sheet based on the Fleet Management Plan document
fleet_overview_data = {
    "Fleet ID": [],
    "Vehicle Type": [],
    "Plate Number": [],
    "Vehicle Color": [],
    "Model Year": [],
    "KM Driven": [],
    "Insurance Expiry": [],
    "Mulkiya Expiry": [],
    "Assigned To": [],
    "Current Driver": [],
    "Status": [],
    "Remarks": []
}

renewal_alerts_data = {
    "Fleet ID": [],
    "Insurance Expiry": [],
    "Mulkiya Expiry": [],
    "Days to Insurance Expiry": [],
    "Days to Mulkiya Expiry": []
}

driver_assignment_data = {
    "Fleet ID": [],
    "Vehicle Type": [],
    "Assigned Driver": [],
    "Designation": [],
    "Contact Number": [],
    "License Expiry": []
}

maintenance_tracker_data = {
    "Fleet ID": [],
    "Last Service Date": [],
    "Next Service Due": [],
    "Service Type": [],
    "Service Provider": [],
    "Cost (AED)": [],
    "Remarks": []
}

fuel_log_data = {
    "Fleet ID": [],
    "Date": [],
    "KM Reading": [],
    "Fuel Added (L)": [],
    "Fuel Cost (AED)": [],
    "Driver": [],
    "Remarks": []
}

# Create Excel writer and write each sheet
excel_path = "/mnt/data/Fleet_Management_Complete_Template.xlsx"
with pd.ExcelWriter(excel_path, engine='openpyxl') as writer:
    pd.DataFrame(fleet_overview_data).to_excel(writer, sheet_name="Fleet Overview", index=False)
    pd.DataFrame(renewal_alerts_data).to_excel(writer, sheet_name="Renewal Alerts", index=False)
    pd.DataFrame(driver_assignment_data).to_excel(writer, sheet_name="Driver Assignment", index=False)
    pd.DataFrame(maintenance_tracker_data).to_excel(writer, sheet_name="Maintenance Tracker", index=False)
    pd.DataFrame(fuel_log_data).to_excel(writer, sheet_name="Fuel Log", index=False)

excel_path
Reply all
Reply to author
Forward
0 new messages