Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
- vba-excel
- sql
- library
Repository Index
47,133 repositories indexed
1–4 of 4 · Most stars
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
- csv-parser
- csv-reader
- csv-writer
- utf-8
A powerful library extending VBA with over 100 functions for math, stats, finance, and data manipulation. It supports matrix operations, and user-defined functions, enhancing automation and analysis within Microsoft Office and LibreOffice environments for data management, financial calculations, an more.
- equation-systems
- mathematical-expression-parser
- mathematical-expressions-evaluator
- determinant-calculation
Run DuckDB inside Excel VBA: pandas-style analytics via in-process SQL + native C bridge. High-speed Range/Array ingestion, Parquet/CSV/JSON I/O.