Import excel file with color format

[Surya]

Hello Team,

I there any possibility to import a excel file along with it' s background color format? if it's possible very helpful for me

Thanks in advance...!

Regards,

Surya

[messi007]

@Surya,

Please take a look on this post, you can do it using python

https://community.alteryx.com/t5/Base-de-Connaissance-Francais/Extraire-la-couleur-des-cellules-d-un... 

Or you can check this post (using VBA)

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Recognizing-cell-colors-in-excel/td-p/... 

Hope this helps,

Regards,

[Surya]

@messi007 

Thank you so much for your immediate response, i will test and let you know

[NJT]

I've got a similar question, where people have formatted rows in a spreadsheet with a color that corresponds to a legend that has the value I actually want to add as a column to each row based on the color the row is matching the color from the legend.. Ideally I could get these people to just add a column to that spreadsheet instead of color coding things.