Awesome GitHub RepositoriesSpreadsheet Data Validation

ExcelJS is a Node.js spreadsheet engine and manipulation library used for reading, writing, and modifying XLSX and CSV files. It functions as a formatting tool and asynchronous streaming parser for generating complex workbooks containing formulas, rich text, and custom styles. The library is distinguished by its ability to process large datasets using asynchronous data streaming and incremental processing, which minimizes memory usage during data extraction and file generation. Its capability surface covers comprehensive data management, including structured tables, named ranges, and cell da

This is a Go library for reading and writing XLSX files, providing a toolkit for spreadsheet generation and data extraction. It functions as an Office Open XML parser and generator, enabling the creation of workbooks with support for styles, formulas, and metadata. The project features a data mapper that uses Go struct tags and reflection to automatically align spreadsheet rows with structured data. It also includes a validation engine for defining input constraints, such as dropdown lists and error alerts, to control user data entry. The library covers a broad range of capabilities, includi

Wuhan2020 is an open platform for collecting, validating, and visualizing epidemic relief data, originally focused on coordinating community response during the COVID-19 crisis. It aggregates information on hospitals, factories, logistics providers, hotels, and donations from multiple sources into a central repository, making it accessible through an interactive geographic map and a programmatic API. The platform distinguishes itself by using GitHub issues as its primary data store, with label-driven organization and command-based task assignment that allows volunteers to claim and track work

This project is a Model Context Protocol server that provides an interface for AI agents to programmatically create, read, and modify Excel workbooks. It serves as a bridge that enables large language models to perform spreadsheet automation and data visualization. The server allows AI agents to generate native Excel charts and pivot tables from raw data, transforming structured information into visual summaries. It provides a mechanism for remote spreadsheet management through a protocol-based connectivity layer. The system covers a broad range of spreadsheet manipulation capabilities, incl

XlsxWriter is a library for generating spreadsheets in the XLSX format, functioning as an Excel workbook writer and file generator. It provides the capability to write data, apply cell formatting, and build complex layouts across multiple worksheets. The project distinguishes itself with a memory-optimized writing mode that flushes large datasets to disk row-by-row, enabling the creation of files exceeding 4 GB while minimizing RAM consumption. It also includes a specialized mechanism for embedding binary project files and digital signatures to enable VBA macros and signed scripts within work

Această aplicație este un tracker de finanțe personale care utilizează o foaie de calcul bazată pe cloud ca bază de date principală pentru înregistrarea și organizarea cheltuielilor zilnice. Oferă un dashboard bazat pe web pentru gestionarea tranzacțiilor individuale și generarea de rezumate lunare pentru a ajuta la supravegherea bugetului. Proiectul se distinge prin utilizarea stocării bazate pe foi de calcul pentru a permite gestionarea financiară colaborativă, permițând mai multor utilizatori să acceseze și să actualizeze înregistrările partajate în timp real. De asemenea, automatizează întreținerea înregistrărilor prin programarea tranzacțiilor recurente și integrarea cu servicii externe de flux de lucru, asigurând introducerea consistentă a datelor fără intervenție manuală. Sistemul include instrumente analitice pentru procesarea înregistrărilor stocate pentru a identifica tiparele de cheltuieli și tendințele istorice. Construit ca o aplicație web progresivă, suportă accesul offline și poate fi instalat pe dispozitive mobile pentru a oferi o interfață nativă pentru gestionarea datelor financiare pe diferite platforme.