xlwings
ipykernel
Our great sponsors
xlwings | ipykernel | |
---|---|---|
25 | 7 | |
2,834 | 612 | |
1.2% | 1.8% | |
8.5 | 8.5 | |
17 days ago | 11 days ago | |
Python | Python | |
GNU General Public License v3.0 or later | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
xlwings
-
Python in Excel: Combining the Power of Python and the Flexibility of Excel
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.
- Microsoft is bringing Python to Excel
- Python for Excel: A Modern Environment for Automation and Data Analysis
-
Running python from excel
xlWings https://www.xlwings.org/
-
Creating slicers with xlwings
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
-
VM for python automation projects
Also you can also use xlwings library to build an excel add-on to replace or even augment VBA.
-
Help with Python automation at work to free up time as single Dad.
You want xlwings (my preferred) or openpyxl
-
[Question] Can I automate this? Sending emails with a file that needs to be updated.
You could look at using Python from Excel using xlwings.
-
Microsoft upgrades Office security by blocking VBA macros by default
Xlwings is superior anyway.
-
Any ways to use excel to run a, say, python script?
xlwings - open source and free - https://www.xlwings.org/
ipykernel
-
Why am I so terrible at Python?
The way I work is to use an interactive IPython REPL. It has a lot of features to make interactive development comfortable. I solve a problem incrementally, attempting to get a little piece of code right many times, changing it a little each time to fix bugs. Then I go back and copypaste the lines into a file and tidy it up a little. Then I go back to IPython and solve the next little stage of the problem. Maybe this style of development will be more fitting for you?
-
Importing?
IPython
- IPYTHON? What's that??
-
Django python manage.py shell up arrow in Git Bash
If you're talking about history in the python shell, you're probably looking for IPython.
-
As we smash many of our previous COVID-19 records yet again, here's the recent cases broken down by sex and age groups.
For this kind of thing I mostly use Jupyter and the IPython kernel, with data analysis packages like numpy and pandas and matplotlib for charts.
-
Jupyter notebook kernel goes offline
Otherwise you should be able to convert the .ipynb's to .py using the ipython libraries:
-
Excel Never Dies
Nice product, I noticed that you are updating the next Jupyter cell; what was your solution to doing that reliably since `set_next_input` is so damn flakey?
I personally grew so frustrated with the state of GUI development in Jupyter that I tried to fix it in such a way that would allow proper message passing between cells and python code (because you can't wait on Comm events).
> https://github.com/ipython/ipykernel/pull/589
But sadly the priorities of big open source projects don't always match your own. So I had to extract that logic into my own kernel.
What are some alternatives?
openpyxl
ipython-cells - IPython extension for running code blocks in .py files
XlsxWriter - A Python module for creating Excel XLSX files.
akernel - Asynchronous Python Jupyter kernel
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
xlwt
copypaster - Make web forms copy-pasteable.
python-docx - Create and modify Word documents with Python
pyright - Static Type Checker for Python
python-pptx - Create Open XML PowerPoint documents in Python
public_images - for more control than imgur