I have a spread sheet with a bunch of colors in it and I really dont feel like typing them all in. Can I do this automatically with python? I've opened one and it is a binary file so I would need to know the encoding to use struct on it.
Arcpy does not offer the possibility to create a new style and create new items. See: StyleItem—Help | ArcGIS for Desktop
For this you would require ArcObjects.
Geez. Why cant syles just be in json? Always gotta use proprietary formats don't you esri?
Would be nice to have that option or access to a finer grained object model in python.
For now you could use ArcObjects in Python (see this example: Create a new MXD through Python. ). For VB code to manipulate the Styles, see this old post: Add a Symbol to the Style Gallery
Or just use VBA ArcObjects if you have the "license" activate on your system.
Retrieving data ...