Excel Formatting with Python and PyXLL

preview_player
Показать описание
Learn how to format the results of worksheet functions and macros in Microsoft Excel with Python and PyXLL.

UDF Formatting: 0:55
Pandas Dataframe Formatting: 3:05
Macro Formatting: 4:08
Custom Formatters: 6:12
Рекомендации по теме
Комментарии
Автор

I keep hearing Alteryx is a replacement for excel macros and while I agree VBA is slow and clunky, I think using Python (Pyxll) is really the right solution!

viertelasiat
Автор

Hope that you guys can rewrite the documentation, because it's truthy complex and hard to find what customers need

tadsoop