xlwings
pymorphy2
Our great sponsors
xlwings | pymorphy2 | |
---|---|---|
25 | 1 | |
2,836 | 1,099 | |
1.3% | 0.8% | |
8.4 | 0.0 | |
7 days ago | 12 days ago | |
Python | Python | |
GNU General Public License v3.0 or later | MIT 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.
[1] https://www.xlwings.org/
- 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/
pymorphy2
What are some alternatives?
openpyxl
PyPDF2 - A pure-python PDF library capable of splitting, merging, cropping, and transforming the pages of PDF files
XlsxWriter - A Python module for creating Excel XLSX files.
WeasyPrint - The awesome document factory
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
csvkit - A suite of utilities for converting to and working with CSV, the king of tabular file formats.
xlwt
tablib - Python Module for Tabular Datasets in XLS, CSV, JSON, YAML, &c.
python-docx - Create and modify Word documents with Python
PDFMiner - Python PDF Parser (Not actively maintained). Check out pdfminer.six.
python-pptx - Create Open XML PowerPoint documents in Python
ReportLab