This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am currently on a project to convert a series of python scripts to Alteryx. While going through the scripts I have realized that part of the python is reading colors from the excel sheets I need to read in Alteryx. After doing some research I know it isn't possible to read colors from excel sheets in Alteryx due to the source formatting getting dropped off after input. I do know I could use the run command tool where I can input the current python script into, but the configuration of the tool is throwing me off and it doesn't seem to be working. If anyone could help me out I would greatly appreciate it.
If you open your .xlsx file as a zip archive (from within Alteryx), you can access the underlying metadata where cell colours are defined. I'm actually working on creating a macro to achieve this but that is far from complete.
Take a look at this post which outlines a starting point.
Thank you, I will look into that, the other thing i forgot to mention though is that I am on a time crunch, so it would probably be easier to go with the python script for now since it is already working. Just need to figure out how to configure the tool.