I have a task to remove duplicate entries from a column in a spreadsheet. I can loop through the spreadsheet using
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.
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.