datapane VS xlwings

If you're looking for an easy way to build an HTML report using Python, you might find Datapane (https://github.com/datapane/datapane) helpful. I'm one of the people building it! We don't support polars (yet, on the roadmap) but we do support pandas so you can convert to a pandas DataFrame and include your data and any plots, etc.

If you're interested in an easier way to create reports using Python and Plotly/Pandas, you should check out our open-source library, Datapane: https://github.com/datapane/datapane - you can create a standalone, redistributable HTML file in a few lines of Python.

You might be interested in what we're hacking on at Datapane (I'm one of the founders): https://github.com/datapane/datapane.

You can create standalone HTML data reports from Python/Jupyter in ~3 lines of code: https://docs.datapane.com/reports/overview/

You can build web apps from Jupyter using Datapane [0]. I'm one of the founders, so let me know if I can help at all.

You can either export a static site [1] (and host on GH pages or S3), or, if you need backend logic, you can add Python functions [2] and serve on your favourite host (we use Fly).

We have specific Jupyter integration to automatically convert your notebook into an app [3].

[0] https://github.com/datapane/datapane

[1] https://docs.datapane.com/reference/reports/#datapane.proces...

[2] https://docs.datapane.com/apps/overview/

[3] https://docs.datapane.com/reports/jupyter-integration/#conve...

Our GitHub is https://github.com/datapane/datapane and you can get started here: https://docs.datapane.com/quickstart/

Thanks a lot! Yes, absolutely, a few people have brought this up and working working on removing the header right now. If I can help at all, feel free to reach us on GH Discussions: https://github.com/datapane/datapane/discussions

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/