advanced-formula-environment
xlite
| advanced-formula-environment | xlite | |
|---|---|---|
| 3 | 16 | |
| 103 | 1,230 | |
| 0.0% | - | |
| 0.0 | 0.9 | |
| over 1 year ago | about 1 year ago | |
| Rust | ||
| MIT License | 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.
advanced-formula-environment
-
What products are most often sold together?
This is the Advanced formula environment from Microsoft that lets you edit formulas in an IDE like interface. That screenshot you gave me that has the formula I gave you is just a normal formula you can put inside the formula bar. This just lets you edit it easily, but it's not required. When you paste in the formula, you can expand the formula bar and make it taller.
-
Excel Never Dies
Related project: https://aka.ms/get-afe
-
Xlite: Query Excel, Open Document spreadsheets (.ods) as SQLite virtual tables
Do you have a workaround workflow in the meantime? I could imagine a few non-Macro or Macro-light solutions to this. Use a pivot table for example, the results of which I believe get 'magiced' into their destination cells instead of getting hidden, I however don't recall whether they auto-inherit autofilters set on the source table.
How much organizational (not technical, we'll get to that) control/authority/input/stakeholder role do you have on the source document templates?
Also, you might want to check out https://github.com/microsoft/advanced-formula-environment/
xlite
-
Show HN: Query Your Sheets with SheetSQL
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
-
Query Google Sheets as virtual tables with SQLite extension – libgsqlite
This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.
-
A SQLite extension for reading large files line-by-line
Hey, author here, happy to answer any questions! Also checkout this notebook for a deeper dive into sqlite-lines, along with a slick WASM demonstration and more thoughts on the codebase itself https://observablehq.com/@asg017/introducing-sqlite-lines
I really dig SQLite, and I believe SQLite extensions will push it to another level. I rarely reach for Pandas or other "traditional" tools and query languages, and instead opt for plain ol' SQLite and other extensions. As a shameless plug, I recently started a blog series on SQLite and related tools and extensions if you want to learn more! Next week I'll be publishing more SQLite extensions for parsing HTML + making HTTP requests https://observablehq.com/@asg017/a-new-sqlite-blog-series
A few other SQLite extensions:
- xlite, for reading Excel files, in Rust https://github.com/x2bool/xlite
- sqlean, several small SQLite extensions in C https://github.com/nalgeon/sqlean
- mergestat, several SQLite extensions for developers (mainly Github's API) in Go https://github.com/mergestat/mergestat
- Processing Excel files in SQLite
- What's everyone working on this week (26/2022)?
- SQLite extension to query Excel spreadsheets (.xls, .xlsx, .ods)
- SQLite extension to query Excel (.xlsx, .xls, .ods) files as virtual tables
- Xlite。将Excel和Open Document电子表格作为SQLite虚拟表进行查询 (Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables)
- Interesting project? dynamic lib, .so .dll, Xlite SQLite
What are some alternatives?
123elf - A native port of Lotus 1-2-3 to Linux.
spacedrive - Spacedrive is an open source cross-platform file explorer, powered by a virtual distributed filesystem written in Rust.
cppyy
uom - Units of measurement -- type-safe zero-cost dimensional analysis
visidata - A terminal spreadsheet multitool for discovering and arranging data
asammdf - a rust crate to parse and write ASAM MDF file.
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
Envy - Envy. Multi P2P Filesharing+Bittorrent, Shareaza Legacy.
rusqlite - Ergonomic bindings to SQLite for Rust
shallow-understanding - math library i don't know enough to finish lol
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊