Hmm, I'm not sure about that! Formatting in Python, sure - because it's not designed for outputting colours and type face. But the popular Python package, Pandas, makes Excel-like tasks a breeze. I'll often help colleagues who can't code to do something with their data that is nothing more than a single "groupby" or "apply" expression in Python+Pandas.
The combination of UI and live calculation engine is unique.
How long does it take to make a pivot table with conditional formatting in Python?
How long does it take to have input validation in JavaScript?
Sure maybe a couple hours. But it takes literally 2 seconds in Excel.
Couple Excel with a fonctional programming addin and you’ll beat a Python programmer on 90% of data oriented tasks you may want to do.