Export to Excel or CSV

Yes, you can do a Save As and select the .xml format. You can open a .xml file in Excel

You can copy and paste from the table but this isn’t very nice. I couldn’t get the xml import to Excel working even when using PowerQuery – it only imports the top row. Surely export to CSV is the way forward here.

import pandas as pd

# Create Gantt task data
data = {
“ID”: list(range(1, 26)),
“Task Name”: [
“Project kickoff meeting”,
“Requirement gathering”,
“Define system features (9 features)”,
“Create project scope draft”,
“Design ERD (Mermaid code)”,
“Create SQL structure (7 tables)”,
“Review & validate DB design”,
“Create homepage UI”,
“Task management UI”,
“Calendar view UI”,
“Reminders & progress UI”,
“Implement login system”,
“Connect UI to database”,
“Implement task CRUD operations”,
“Implement scheduling + reminders”,
“Implement progress tracking”,
“Functional testing”,
“Fix bugs and refine UI”,
“Write Business Case”,
“Write Scope Statement”,
“Write Project Charter”,
“Insert diagrams & screenshots”,
“Prepare presentation slides”,
“Rehearse presentation”,
“Final submission”
],
“Duration”: [
“1d”,”2d”,”1d”,”1d”,”2d”,”2d”,”1d”,”2d”,”2d”,”2d”,”2d”,
“2d”,”2d”,”3d”,”3d”,”2d”,”3d”,”2d”,”2d”,”1d”,”1d”,”1d”,
“2d”,”1d”,”1d”
],
“Predecessor”: [
“”, “1”, “2”, “3”, “4”, “5”, “6”, “7”, “8”, “9”, “10”,
“11”,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,
“22”,”23″,”24″
]
}

df = pd.DataFrame(data)

# Save CSV file
csv_path = “/mnt/data/Sajilo_Study_Planner_Gantt.csv”
df.to_csv(csv_path, index=False)

csv_path
`