Recognizing cell colors in excel

echenty

Hello! Does anyone know if Alteryx can recognize cell colors from excel? I have a report that has been color-coded and I'd like to bring this dimension of detail into my dataset. Has anyone done this before? I've attached the excel file. Sheets I'm looking to parse are on sheet 49 and 50.

Thanks!

NLCA Report - Converted to Excel.xlsx

jdunkerley79

Alteryx's import is only the data not the formatting of the source document.

I think the easiest way is to do create a small VBA macro to extract the colour to a new column containing the colour and then you can import.

Something like:

Option Explicit

Function CellColour(ByRef targetCell As Range)
    CellColour = targetCell.Interior.Color
End Function

will give you an colour code for each cell.