Codcel Documentation¶
Welcome to the official documentation for Codcel -- a platform that transforms Excel spreadsheets into real, production-ready software.
Codcel reads your annotated Excel workbooks and generates:
- Source code in languages such as Rust, Python, Java, C#, Go, Swift, Kotlin, JavaScript/TypeScript, and more
- Calculation engines (Codcel Calculation Engine -- open source, Rust)
- Table engines with CRUD functionality and high-performance columnar storage (Codcel Table Engine -- open source, Rust)
- REST APIs, UI components, and MCP servers
- Fully-structured, human-readable code your team owns
Codcel allows businesses and developers to move instantly from prototype spreadsheets to maintainable software -- while keeping complete control of source code.
Official Website¶
Visit the main website for product details, downloads, pricing, and examples:
https://codcel.io
Download Codcel¶
The Codcel Desktop app (Windows, macOS, Linux) can be downloaded from the Codcel website. The desktop app runs entirely locally and is used to import spreadsheets, annotate them, and generate software projects.
Open-Source Projects¶
Codcel provides several open-source components written in Rust:
-
Codcel Calculation Engine Excel-compatible formula engine supporting hundreds of functions.
-
Codcel Table Engine High-performance columnar table engine used by generated code.
-
Codcel Parquet Engine Read and write Apache Parquet files for efficient big-data storage.
-
Codcel PostgreSQL Engine Connect generated applications directly to PostgreSQL databases.
-
Codcel Documentation (this site) All documentation is open source and community-improvable.
How This Documentation Is Structured¶
This documentation covers:
- How to use the Codcel desktop app and CLI
- How Codcel interprets Excel spreadsheets, annotations, and settings
- What output targets are available — calculation libraries, REST servers, web clients, fullstack UI, and integrations (OpenAPI, CLI, MCP, JNI, FFI)
- How tables, CRUD operations, and named ranges work
- Excel concepts like dynamic arrays, functional programming, and circular references
- Reference documentation for all supported Excel functions
- How Codcel handles large datasets (Big Data + One Billion Row Challenge)
- Differences between Codcel and Excel
- Troubleshooting with error and warning codes
- Architecture overview
Use this index as a guide to every major topic.
Documentation Index¶
Getting Started¶
- Introduction
- Desktop Application Guide
- Excel to Code
- Excel Guidelines
- Annotations
- Settings Reference
- Runtime Formatting
- Command Line Interface
- Testing and Validation
Output Targets¶
- Output Targets Overview
- Calculation Libraries
- REST Servers
- Web Clients
- Fullstack UI
- Integrations (OpenAPI, CLI, MCP, JNI, FFI)
- Excel Python Interface (xlwings, .xlsm workbooks)
- Excel Web Client Python Interface (xlwings, .xlsm workbooks via REST API)
Tables & Data¶
Excel Concepts¶
Excel Function References¶
- Alphabetical Function List
- Mathematical Functions
- Statistical Functions
- Text Functions
- Conditional Functions
- Engineering Functions
- Financial Functions
- Logical Functions
- Compatibility Functions
- Date & Time Functions
- Lookup & Reference Functions
- Information Functions