Python in Excel is an alternative to the Excel formula language and has use cases for computationally intensive tasks, AI, advanced visualizations, and time-series analysis. However, it is not suitable for beginners or interactive data analysis. There are also restrictions such as not being able to use custom packages or connect to web APIs.
Table of contents
Table of ContentsMake something people wantThe mistake: placing the Jupyter notebooks cells inside the gridPython in Excel the CloudA glue language without glueMatplotlib is great, but a little interactivity wouldn’t hurtNo access to the Excel object modelDataFrames are great, but so are NumPy arrays and listsA better alternative than “an alternative to the Excel formula language”What are my plans with xlwings?ConclusionSort: