Hello
Ive recieved an excel sheet from a colleague, which functions as a Gannt chart describing a project plan, see the image.
rows describe different activities, while the columns represent dates. The different colours indicate that the activity is running, and what person is responsible at that date.
My task is to try and translate this information into a more conventional format - namely to extract the start and end dates of an activity. I think i have most of it figured out, but i need a way to get information on the colour formatting in the excel sheet.
Other posts describe using VBA in the sheet to identify colours, but i would like to avoid editing the input sheet, as the intention is that I pull directly from a live sheet, that they may edit at any time. The other go to method seems to be utilizing python, but unfortunately my company has some restrictions on downloading packages, that means that getting the prerequisites for the script someone has linked, would be a longer process.
I was therefore hoping that there is some trick im missing to import the cell colours? any input would be greatly appreciated
