Tidy way to extract colour annotations when reading excel sheet

Sometimes I encounter excel sheets, which have been created with colour annotations.

Given a set of variables and observations an extra layer is added manually by adding colour codes to each cell, where the colours are independent of the values in the sheet.

Is it possible in a tidy way to extract these additional annotations? I have found some online examples here and here, but they are not tidy

Perhaps in a long format, something along the lines of

column    row    value    annotation
A         1      2        red
A         2      1        yellow
A         3      0        white
...

You might try here: https://nacnudus.github.io/tidyxl/

2 Likes