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