xlwings VS MicroPyScript

Reading the headline, I initially thought that Microsoft bought the company behind XLWings [1], which also enables you to use Excel directly within Excel, even locally. Not affiliated in any kind to that company, just used it in the past.

[1] https://www.xlwings.org/

xlWings https://www.xlwings.org/

I'm trying to automate a report and I know xlwings does not support pivot tables and slicers, as it is essentially a pywin32 wrapper. You can directly reference the COM object using .api and constants

Also you can also use xlwings library to build an excel add-on to replace or even augment VBA.

You want xlwings (my preferred) or openpyxl

You could look at using Python from Excel using xlwings.

Xlwings is superior anyway.

xlwings - open source and free - https://www.xlwings.org/

> And currently using anything but C, C++ or Rust isn't feasible

Someone should tell Anaconda that they can't do this, then: https://pyscript.net/

There's https://pyscript.net/ -- or do you mean for scripting the browser's behaviour rather than replacing JS in website code?

Icepool is a Python package. If you know Python, you have a head start in understading Icepool's syntax. Icepool is written in pure Python and has no dependencies other than the Python Standard Library, allowing you to run it in most places you can run Python. You can directly interoperate Icepool with the extensive Python ecosystem, including Numpy, Matplotlib, and Pandas. Recent projects such as Pyodide, JupyterLite, and PyScript allow Icepool to interoperate with JavaScript, allowing you to make your own web applications using Icepool.

But we're not stuck with one or the other. Python-JS interop has improved greatly in recent years with projects like Pyodide, JupyterLite, and PyScript. Often my strategy is to do the probability in Python and use JS for visualization, as you can see in this ability score calculator or this AnyDice-like interface.

same was done for other languages too, like Python https://pyscript.net/

Finally, there's PyScript. The dream of many Python developers, PyScript allows Python to run in the browser using WebAssembly. As someone who never fully mastered JavaScript, I find this particularly appealing.

I assume your goal is to write the least amount of JavaScript. There's actually a way to run Python in your browser. Take a look at pyscript.net. Not everything is supported, however, so you'd have to check whether the dependencies of the tools you have developed can run.

PyScript. I made a small single-page site that translates code into english with it. Really neat learning experience.