xlwings
copypaster
Our great sponsors
xlwings | copypaster | |
---|---|---|
25 | 10 | |
2,836 | 96 | |
1.2% | - | |
8.4 | 0.0 | |
3 days ago | over 1 year ago | |
Python | JavaScript | |
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.
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/
copypaster
-
Show HN: Book about forms usability for devs
If you are not using Tree Notation for your forms yet, you are doing it wrong: https://github.com/breck7/copypaster
- 18 second animated GIF vs. $1B a year on software engineers
- Make web forms copy-pasteable.
- The future of web forms
- The Future of Web Forms
-
Excel Never Dies
I figured out how to do this years ago, even before I worked at Microsoft (and pitched it while there a number of times).
It wasn't easy, and there was a lot to figure out, but the end result is starting to look pretty simple:
https://youtu.be/vn2aJA5ANUc?t=145
https://github.com/publicdomaincompany/copypaster
- CopyPaster: using Tree Notation for Web Forms
- A design pattern you can use to make web forms copy/pasteable and spreadsheets
- A notation that makes web forms into copy/pasteable plain text documents that also can be edited in a spreadsheet
- Show HN: Make all web forms copy/pasteable as a single form. Web 3.0
What are some alternatives?
openpyxl
ipykernel - IPython Kernel for Jupyter
XlsxWriter - A Python module for creating Excel XLSX files.
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
SheetJS js-xlsx - 📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
xlwt
scroll - Tools for thought. An extensible alternative to Markdown.
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.
docxtpl - Use a docx as a jinja2 template