- able to load ical files and fill a pandas database
- parse the pandas database to identify project and creates a worksheet tables
- export to open document XLSX file
pip install --upgrade icalreporting
This automatic installation will get needed dependencies.
see requirements.txt
When installed, you just need to put a set a ical files in a folder for a project. You will be able to create a reporting file with the following lines.
from icalreporting.reporting import Project
prj = Project(name="Big-Project", folder="examples/projectA", start="2023-01-01", end="2024-01-01")
prj.load_ics() # read files
wb = prj.workbook() # create workbook
wb.save("projectA.xlsx") # save it to file