23 个仓库
Capabilities for creating and populating spreadsheet files programmatically.
Distinguishing note: Focuses on creation and export rather than reading or analysis.
Explore 23 awesome GitHub repositories matching data & databases · Spreadsheet Generators. Refine with filters or upvote what's useful.
Polars is a high-performance columnar data processing library designed for efficient analytical workflows. It functions as a structured data library that organizes information into typed columns, utilizing the Apache Arrow memory format to enable zero-copy data sharing and cache-friendly, vectorized operations. The engine is built to handle large-scale tabular datasets, providing both local and distributed analytical runtimes that scale from single-machine environments to multi-node clusters. The project distinguishes itself through a sophisticated lazy query engine that constructs abstract e
Creates new spreadsheets programmatically and populates them with dataset content.
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
Creates spreadsheet files from data objects or raw values using simple grids or multi-level headers.
React-admin is a framework for building data-driven administrative interfaces that connect to REST or GraphQL backends. It provides a comprehensive suite of tools for managing the full lifecycle of administrative applications, including resource-oriented routing, declarative form scaffolding, and context-driven state management. By utilizing a modular adapter-based architecture, the framework abstracts backend communication, allowing developers to build consistent CRUD interfaces that handle data fetching, authentication, and synchronization automatically. The project distinguishes itself thr
Generates downloadable files from grid content for external spreadsheet software.
This project is a comprehensive educational guide and framework for building web scrapers using Python. It provides a course-based approach to data extraction, combining a Python crawler framework with tutorials on web reverse engineering and network traffic analysis. The project distinguishes itself by covering advanced extraction challenges, including the decryption of obfuscated JavaScript and the bypass of anti-scraping measures. It specifically addresses mobile application scraping through the simulation of user interactions and the interception of network traffic. The capability surfac
Writes collected information into structured spreadsheet files with defined columns and rows.
Excelize is a Go library designed for reading, writing, and modifying Microsoft Excel files in XML-based formats. It functions as a spreadsheet file parser and generator that enables the programmatic extraction and modification of data. The library includes a streaming spreadsheet processor to handle massive datasets incrementally, preventing system memory exhaustion during large-scale read and write operations. It also provides a chart generator to convert worksheet values or external data sources into visual representations within the spreadsheet. Beyond core file processing, the project c
Programmatically creates Microsoft Excel files to automate report and data table production.
Excelize is a library for reading and writing spreadsheet files in the Office Open XML format. It provides a comprehensive suite of tools for programmatically creating, modifying, and analyzing workbooks, worksheets, and cell data, ensuring compatibility across various office software suites through structured XML serialization. The library distinguishes itself with a built-in formula calculation engine that evaluates complex mathematical and logical expressions directly against workbook data. It also features a memory-mapped streaming architecture, which allows for the efficient processing o
Provides programmatic creation and modification of spreadsheet files.
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
Provides extensive visual formatting including cell styles, conditional formatting, and page setups.
PhpSpreadsheet is a PHP library used for reading and writing spreadsheet files across various formats. It functions as a spreadsheet file generator and an Excel file parser, allowing for the programmatic creation and manipulation of documents compatible with software such as Microsoft Excel and LibreOffice Calc. The library provides capabilities for programmatic spreadsheet generation and data extraction, enabling the conversion of data from spreadsheet files into programmable PHP formats. It also facilitates cross-format spreadsheet conversion, allowing data to be moved between different sta
Enables the programmatic creation and population of spreadsheet files for external data export.
Laravel-Excel is an integration library for importing and exporting spreadsheet data between Laravel applications and Excel or CSV files. It provides a suite of tools for bidirectional spreadsheet integration, including a system for reading workbooks and mapping data into database models. The library distinguishes itself through a background processing system that handles large imports and exports using chunking and job queues. It supports template-driven exports by converting HTML tables from view templates into spreadsheet cells. The toolset covers broad capabilities for large dataset proc
Provides comprehensive capabilities for programmatically creating and populating Excel and CSV files.
This is a Laravel Excel integration library used for importing and exporting spreadsheet files within the Laravel framework. It functions as both a spreadsheet data exporter for converting database queries and collections into files and a spreadsheet data importer for mapping workbook data to database models. The library includes an HTML to spreadsheet converter that transforms HTML table templates into downloadable documents to preserve specific layout designs. It supports large dataset exports via background queuing and processes bulk data imports through chunked reading and batch inserts.
Programmatically creates and populates spreadsheet files from application data and database queries.
PHPExcel is a PHP spreadsheet library used for programmatically reading and writing spreadsheet files in various formats. It utilizes an in-memory spreadsheet model that maps spreadsheet structures to a hierarchy of objects for programmatic manipulation. The library functions as an Office Open XML processor for generating and manipulating XLSX documents and serves as a reader for extracting data and structure from legacy binary XLS files. It also includes tools for CSV data integration and importing. The project provides capabilities for automated report generation and spreadsheet data extra
Provides capabilities for programmatically creating and populating spreadsheet files for export.
gspread is a Python client library and API wrapper designed for programmatically interacting with Google Sheets. It serves as a spreadsheet automation library that enables the creation, organization, and management of cloud-based spreadsheets via Python scripts. The library provides a simplified interface for Google Sheets automation, allowing users to read, write, and update data without writing raw HTTP requests. It supports cloud spreadsheet integration, enabling external Python applications to use Google Sheets as a data storage layer. The project covers a broad range of capabilities inc
Allows for the programmatic generation of new spreadsheet files with specified names.
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
Provides capabilities for applying visual formatting like fonts, colors, and borders to exported spreadsheet files.
Reactor Core is a reactive programming toolkit and non-blocking foundation for composing asynchronous data pipelines on the JVM. It serves as an asynchronous stream processing framework and a backpressure management system, allowing developers to transform, filter, and combine sequences of events while regulating data flow between producers and consumers to prevent resource exhaustion. The library differentiates itself through a sophisticated concurrency scheduling system and demand-based flow control. It decouples signal processing from specific threads using a scheduler registry and provide
Enables the production of data sequences using stateful generators that emit items one-by-one.
unioffice is a comprehensive document processing suite that provides a PDF document processor, an Open XML document library, a document security toolkit, and a document content extractor. It is designed to programmatically create, read, and modify Word, Excel, and PowerPoint files, as well as generate and edit PDF documents. The project is distinguished by its native language implementation of the Open XML standard, which removes native binary dependencies to simplify container deployments. It features advanced capabilities for digital document security, including hardware-based PDF signing,
Applies visual styles and conditional formatting to spreadsheet cells to change appearance based on rules.
Spout 是一个电子表格文件处理库和多格式生成器,用于读写 CSV、XLSX 和 ODS 文件。它作为一个基于流的解析器,通过增量处理大型电子表格文件,避免将整个文档加载到内存中。 该库提供了程序化生成电子表格和提取数据的功能。它支持自定义内容样式,允许对单个单元格或行应用字体、背景、边框和数字格式。 除了基本的文件输入输出外,该项目还涵盖了工作簿操作,包括选择性提取工作表以及修改现有文件中的特定内容。它采用内存优化策略,无论文件总大小如何,都能处理大规模电子表格。
Enables the programmatic creation and population of formatted XLSX and ODS files from code.
GAM is a command-line tool for administering Google Workspace and Cloud Identity. It translates command-line arguments into structured API calls, enabling administrators to manage users, groups, organizational units, and domain settings across a Google Workspace environment. The tool handles authentication through OAuth2 flows, service accounts, and workload identity federation, and supports multi-tenant configurations for managing multiple domains or cloud projects from a single installation. GAM distinguishes itself through its batch processing and automation capabilities. It can process la
Generates new spreadsheets programmatically from JSON data and places them in specified Drive locations.
coobjc 是一个 Objective-C 协程库,提供 await 方法和生成器,以简化 Objective-C 和 Swift 中的异步编程。它实现了非阻塞工作流,消除了嵌套回调和线程阻塞。 该工具包包括一个非阻塞 Foundation 包装器,可将同步的 Foundation 和 UIKit API 转换为可挂起的操作。它提供了一个用于通过 yield 按需生成值的惰性序列生成器,以及一个基于通道的通信工具,用于使用缓冲和非缓冲通道在并发任务之间交换数据。 该库涵盖了异步任务协调和状态管理,利用 Actor 模型防止数据竞争。其功能包括协程调度、取消,以及在不冻结用户界面的情况下执行文件系统和网络操作的能力。
Implements generators that produce sequences of values where each element is fetched via an async operation.
这是一个模型上下文协议 (Model Context Protocol) 服务器,为 AI 智能体提供以编程方式创建、读取和修改 Excel 工作簿的接口。它充当桥梁,使大语言模型能够执行电子表格自动化和数据可视化。 该服务器允许 AI 智能体从原始数据生成原生 Excel 图表和数据透视表,将结构化信息转换为可视化摘要。它提供了一种通过基于协议的连接层进行远程电子表格管理的机制。 该系统涵盖了广泛的电子表格操作功能,包括用于公式和数据验证的单元格级操作、范围的视觉格式化以及布局修改。它还处理工作簿级管理,例如元数据提取、工作表组织和结构化表的创建。
Generates new spreadsheet documents programmatically based on provided data and requirements.
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
Formats cells with percentages, dates, and custom styles for professional visual presentation.