Awesome GitHub RepositoriesColumn Expression Modifiers

EasyExcel is a Java processing library designed for reading and writing XLS, XLSX, and CSV files. It functions as a memory-efficient spreadsheet parser, an object-relational mapper that binds spreadsheet columns to Java class fields, and a stream-based exporter for handling high-volume data. The library distinguishes itself through a streaming model that processes large files row-by-row via listeners to prevent heap memory overflow. It also operates as a template engine, allowing the population of predefined spreadsheet files with dynamic data while preserving original layouts and styles. Br

SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a

VisiData is a terminal-based interactive data analysis tool and browser designed for exploring, filtering, and sorting large tabular datasets. It functions as a structured data inspector that loads and flattens complex formats like JSON, XML, and PCAP into interactive sheets, as well as a terminal file manager for navigating directories and performing staged filesystem operations. The project distinguishes itself by rendering data visualizations, such as scatter plots and histograms, directly in the terminal using Unicode Braille characters. It provides a Python-based data wrangling environme

Tabulator is an interactive data table library and virtual DOM data grid used to create high-performance tables from JSON or arrays. It functions as a hierarchical data viewer and a spreadsheet interface component, capable of rendering thousands of records efficiently through viewport-based virtualization and progressive loading. The library distinguishes itself by providing a full spreadsheet interface mode with multi-sheet management, cell range selection, and bulk copy-paste capabilities. It supports complex data architectures, including nested data field mapping, expandable tree structure

该项目是一个 SQL 数据访问层和模式生成器，允许通过将表视为简单数据结构来读取和写入关系数据库中的记录。它作为一个自动模式生成器，根据传入数据的结构即时创建数据库表和列。 该工具提供了一个高性能批量加载器，使用分组原子事务导入大数据集以确保数据一致性。它还包括一个记录 Upsert 机制，根据唯一标识符确定是更新现有行还是插入新行。 该系统涵盖动态模式管理，包括隐式列解析和表配置。它还提供了一个基于集合的查询接口，用于检索记录或提取唯一值，而无需编写手动查询。

ExcelDataReader 是一个 C# 库，用于从 Microsoft Excel 电子表格和 CSV 文件中提取数据和元数据。它作为一个工作簿解析器，将电子表格内容转换为结构化数据集，以便进行程序化访问和迭代。 该项目包含一个专门的元数据提取器，用于检索单元格级别的详细信息，例如数字格式、样式、行高、列宽和合并单元格范围。它还提供了一个流处理器，用于解析具有可自定义编码和分隔符检测功能的纯文本 CSV 文件。 该库支持现代电子表格文件的 OpenXML 标准，并利用基于流的解析和基于游标的行迭代来遍历工作簿。这些功能允许将多工作表工作簿转换为关系数据表。