osbxl 官方代码示例库发布：AI 就绪的 C++ 表格计算引擎

🇯🇵 日本語版の README はこちら (README.ja.md)

Official verified code samples and patterns for osbxl (https://osb-office.com) — an AI-ready, ultra-fast C++ core multi-platform spreadsheet calculation and Excel generation engine.

📊 Comparison with Popular Excel Libraries

For in-depth analysis and migration tips, check out our Online Library Comparison Guide.

Pure high-level libraries (Apache POI, openpyxl, PhpSpreadsheet) often suffer from Out of Memory errors, GC pauses, and absent formula calculation engines on large datasets. osbxl’s optimized C++ core eliminates these bottlenecks:

🌟 Key Features

• 🤖 AI-Ready with Zero Hallucinations: Bundled with official AI Skill packages tailored for Cursor, GitHub Copilot, Gemini, and Claude Code. AI generates verified, runnable Excel manipulation code on the first try.
• ⚡ Overwhelming C++ Speed: Native C++ core engine processes large workbooks and complex formula calculations in milliseconds with minimal memory footprint.
• 🌐 5 Supported Platforms: Consistent, clean APIs across Python (pyosbxl), Node.js (nodeosbxl), Java (osbxl), PHP (phposbxl), and WebAssembly (wasmosbxl).
• 📊 Rich Spreadsheet Capabilities: Nearly 500 Excel-compatible functions, charts (bar, line, etc.), AutoFilters, Tables (ListObjects), Conditional Formatting, and PivotTables.
• 🔒 Security: Read and write password-protected, encrypted .xlsx workbooks.

📁 Repository Structure

osbxl-samples/
├── README.md               # Overview and quick reference
├── README.ja.md            # 日本語版 README
├── LICENSE                 # Licenses (MIT for samples, OSBXL agreement for engine)
├── LICENSE.ja.md           # 日本語版ライセンス条項
├── examples/               # Standalone runnable code examples
│   ├── python/             # Python samples
│   │   ├── quickstart.py             # Basic workbook creation & formulas
│   │   ├── chart_sample.py           # Column & line charts creation
│   │   ├── table_comments_sample.py  # Tables (ListObjects) & threaded comments
│   │   └── conditional_format_sample.py # Conditional formatting & data bars
│   ├── nodejs/             # Node.js samples
│   │   ├── quickstart.js             # Basic workbook creation & formulas
│   │   ├── chart_sample.js           # Column & line charts creation
│   │   └── table_comments_sample.js  # Tables (ListObjects) & threaded comments
│   ├── java/               # Java sample (QuickStart.java)
│   ├── php/                # PHP sample (quickstart.php)
│   └── wasm/               # WebAssembly sample (quickstart.wat, quickstart.wasm.js)
├── ja/                     # 日本語版 Web 形式リファレンス (general-01 ~ 11)
└── en/                     # English Web Reference (general-01 ~ 11)

📊 Feature Comparison Matrix & Real-world Benchmarks

A side-by-side comparison of advanced features (formula engine, PivotTables, charts, password encryption) and measured performance between popular open-source libraries and osbxl.

1. Feature Support Matrix

2. Standard 200-Row (800-Cell) Benchmark

Measured under the same development environment (Linux x86_64) generating a standard business report (200 rows × 4 columns = 800 cells + SUM formula).

3. Large-Scale 50,000-Row (200,000 Cells) Stress Test

Stress test results scaling data up to 50,000 rows × 4 columns = 200,000 cells + SUM formula. While popular open-source libraries crash from out-of-memory errors, osbxl completes cleanly across all platforms.

📖 Full Feature Matrix & Detailed Analysis: See Excel Library Feature Comparison & Benchmark Report (en/benchmark-comparison.md). *Note: nodeosbxl and pyosbxl allocate ~950–1,000 MB RSS because they construct a full native formula dependency graph for headless calculation across ~500 functions (Node.js runtime heap is only 31 MB). This differs fundamentally from pure stream serializers like ExcelJS or openpyxl, which perform no formula evaluation.

🚀 Quick Code Examples

Python (pyosbxl)

import pyosbxl

app = pyosbxl.App()
book = app.createWorkBook("sales_report.xlsx")
sheet = book.addWorkSheet("Sales")

sheet.getRange("A1").setValue("Monthly Sales")
sheet.getRange("A2").setValue(150000)
sheet.getRange("A3").setValue(230000)
sheet.getRange("A4").setFormula("SUM(A2:A3)")

book.save()
book.close()

Node.js (nodeosbxl)

const osbxl = require("nodeosbxl");

const app = new osbxl.App();
const book = app.createWorkBook("report.xlsx");
const sheet = book.addWorkSheet("Sheet1");

sheet.getRange("A1").setNumberValue(100);
sheet.getRange("A2").setNumberValue(200);
sheet.getRange("A3").setFormula("SUM(A1:A2)");

book.save();
book.close();

🔗 Official Links & Documentation

• Official Website: https://osb-office.com/
• Excel Library Performance & Features: https://osb-office.com/en/pages/comparison.php
• osbxl vs Famous Libraries Detailed Comparison (200 & 50,000 rows): https://osb-office.com/en/pages/members/benchmark_report.php
• Load Test Benchmark Report: https://osb-office.com/en/pages/members/tips.php
• AI Skill Guide & Download: https://osb-office.com/pages/ai-skill.php
• Interactive Web Samples: https://osb-office.com/sample/
• Product Features: https://osb-office.com/pages/features.php
• Free Demo Download: https://osb-office.com/pages/download.php

📄 License

• Sample Code & AI Skills: MIT License — Feel free to use, copy, and modify in your projects.
• OSBXL Engine (Libraries): Commercial / Proprietary by osb-office.inc. See LICENSE or LICENSE.ja.md for software license agreement details.