can openpyxl read font colors

[mperemsky]

I have a task to remove duplicate entries from a column in a spreadsheet. I can loop through the spreadsheet using

        for i in range(3, self.workbook_sheet.max_row+1):
            row = [cell.value for cell in self.workbook_sheet[i][5:6]]

This cell has multiple text entries in red and green text. I need to determine which text is red and which is green and separate the values.

for example, the following text would exist in one cell. I need to separate the 4 values find out what color they are and record the value.

1234[g]
4567[r]
0192[g]
1234[r]

Is there a way to do this in openpyxl? I have not been able to find a way to do it anywhere.

[gerpark]

I investigated and think your request is about rich text. Rich text can be written to a excel file with openpyxl version 3.1.2,
but can't be read. I did not try but this might be a solution:
openpyxl patch

[gerpark]

This is the link to the problem offering the patch to retrieve the Textdata:

problem description

[MindKeeper]

I had the same question recently, it was described in detail here, maybe it will help you.

buran write May-09-2023, 11:36 AM:
Link removed, it does not address OP question, but it looks very much like clickbite