git-xl
xlwings
Our great sponsors
git-xl | xlwings | |
---|---|---|
2 | 25 | |
535 | 2,834 | |
1.5% | 1.2% | |
1.5 | 8.5 | |
3 months ago | 17 days ago | |
Python | Python | |
MIT License | GNU General Public License v3.0 or later |
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.
git-xl
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/
What are some alternatives?
macro_pack - macro_pack is a tool by @EmericNasi used to automatize obfuscation and generation of Office documents, VB scripts, shortcuts, and other formats for pentest, demo, and social engineering assessments. The goal of macro_pack is to simplify exploitation, antimalware bypass, and automatize the process from malicious macro and script generation to final document generation. It also provides a lot of helpful features useful for redteam or security research.
openpyxl
git-limiter - ⏱️ Tool to stop you from pushing huge diffs
XlsxWriter - A Python module for creating Excel XLSX files.
pcodedmp - A VBA p-code disassembler
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
xlwt
ViperMonkey - A VBA parser and emulation engine to analyze malicious macros.
python-docx - Create and modify Word documents with Python
python-pptx - Create Open XML PowerPoint documents in Python
unoconv - Universal Office Converter - Convert between any document format supported by LibreOffice/OpenOffice.