xlwings
grist-core
Our great sponsors
xlwings | grist-core | |
---|---|---|
25 | 52 | |
2,836 | 6,233 | |
1.3% | 4.2% | |
8.4 | 9.8 | |
6 days ago | 3 days ago | |
Python | TypeScript | |
GNU General Public License v3.0 or later | Apache License 2.0 |
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/
grist-core
-
Ask HN: Who is hiring? (March 2024)
and poke around. If the words battery correct horse staple mean something to you, you might have an advantage.
The heart of the software you'll be working with: https://github.com/gristlabs/grist-core/
-
Form to DB
Because the single-system paradigm doesn't work any more. However, modern replacements do exist, Airtable is one of the first; it's basically the notion of a "spreadsheet with more structure", and then building forms and such on top of that. I've recently been playing with Grist and like it, although it is rough around the edges.
https://www.getgrist.com
- Ask HN: Spreadsheets like Google Sheets but not from Google?
- Show HN: I made an app that consolidated 18 apps (doc, sheet, form, site, chat)
-
A modern, open-source spreadsheet that goes beyond the grid
i want exactly the opposite - something that does not try to be a spreadsheet, but gives me a grid view of a database table, with concurrent edits a la google sheets, and lets me access the same data from my webapp backend.
i have been searching for this for literally years, all the time maintaining an app as a google sheets script, because much as i would prefer something self-hosted and customisable, that collaborative grid view is the ideal user interface from my users' point of view. so far nothing has fit the bill - basetool (https://github.com/basetool-io/basetool) might have but it's discontinued and underdocumented, and i'm not really a web developer so i don't feel up to the challenge of getting it running and integrated into an app.
grist actually came really close from a ui perspective, but it was too focused on being a spreadsheet and doing computation in the frontend. i filed an issue that explains my use case in more detail: https://github.com/gristlabs/grist-core/issues/422
-
Unicorn Startup Airtable Lays Off 27% of Firm, Shifts Focus to Big Clients
Founder of Grist here (https://www.getgrist.com/):
- focus on small teams and individuals
- open source (with community contributing!)
- can be run self-managed
- portable data (lossless export in SQLite format)
- full of great features (granular access rules, formulas with python, conditional formatting, webhooks, etc etc)
If it's little-known, it's because we spend too much time building, not enough time selling.
- Grist Is the Evolution of Spreadsheets
-
From no-code to co-code
The exact LLM used in the experiment mentioned in this post was upstage-llama-2-70b-instruct-v2.ggmlv3.q2_K. Grist was configured to use it via llama-cpp-python and https://github.com/gristlabs/grist-core#ai-formula-assistant...
-
Microsoft is bringing Python to Excel
https://github.com/gristlabs/grist-core/
-
Welcome to Datasette Cloud
Check out Grist in the ‘Access with sane backend’ space. SQLite, open source and fantastic UX https://www.getgrist.com/ and https://github.com/gristlabs/grist-core
I use and love both Datasette and Grist - they’re complementary.
What are some alternatives?
openpyxl
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes 🚀
XlsxWriter - A Python module for creating Excel XLSX files.
authentik - The authentication glue you need.
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
Gotify - A simple server for sending and receiving messages in real-time per WebSocket. (Includes a sleek web-ui)
xlwt
worldle
python-docx - Create and modify Word documents with Python
Trilium Notes - Build your personal knowledge base with Trilium Notes
python-pptx - Create Open XML PowerPoint documents in Python
yunohost - YunoHost is an operating system aiming to simplify as much as possible the administration of a server. This repository corresponds to the core code, written mostly in Python and Bash.