AB
AiBoss
project

Univer - an open-source AI office tool that supports a full-stack solution for document processing, including Word and Excel.

Univer is an open-source, full-stack framework that supports the creation and editing of spreadsheets, documents, and presentations, providing users with a unified and powerful office solution. Univer runs in browsers and Node.js environments and is easily integrated into various...

What is Univer?

Univer is an open-source, full-stack framework that supports the creation and editing of spreadsheets, documents, and presentations, providing users with a unified and powerful office solution. Univer runs in browsers and Node.js environments and is easily integrated into various applications. Univer's cross-platform compatibility, powerful features (including formula calculation, conditional formatting, data validation, etc.), high scalability and customizability, and excellent performance provide users with a modern office tool. Univer supports multiple languages, making it suitable for individual and enterprise users, improving work efficiency.

In the SpreadsheetBench benchmark, UniverAgent ranked first with a pass rate of 68.86%, surpassing mainstream solutions such as ChatGPT Agent and Excel Copilot. Through its unique online hybrid execution architecture, advanced context engineering, and robust CodeAct loop strategy, the tool achieves efficient processing of complex spreadsheet tasks. It understands business requirements, accurately executes tasks, and self-corrects, bringing technological innovation to the field of spreadsheet automation.

Univer's main functions

  • Support for multiple document typesSupports spreadsheets and rich text documents.
  • Multi-terminal isomorphismIt supports running in browsers and Node.js environments, enabling cross-platform operation.
  • Easy to integrateIt can be seamlessly integrated into various applications.
  • powerfulIt includes functions such as formula calculation, conditional formatting, data validation, filtering, collaborative editing, printing, and import/export.
  • Highly scalableIt adopts a plug-in architecture, which makes it easy for users to expand functions according to business needs.

Univer's technical principles

  • isomorphic full-stack frameworkThis includes browsers and Node.js, providing consistent APIs and functionality on both the client and server sides.
  • Canvas rendering engineUse a Canvas-based rendering engine to render documents efficiently and ensure high-quality document display.
  • Formula EngineThe self-developed formula engine is responsible for processing formula calculations in spreadsheets. It has fast calculation capabilities and can run in Web Workers, improving performance and avoiding blocking the main thread.
  • Plug-in architectureThe modular plug-in architecture simplifies feature expansion. Developers can add or develop plug-ins to extend Univer's functionality and meet specific business needs.
  • Collaborative editing (OT algorithm)To support real-time collaborative editing by multiple users, an Operational Transformation (OT) algorithm is used to resolve editing conflicts, ensuring consistency and real-time performance for multi-user editing.

Univer's project address

  • Project official websitehttps://univer.ai/
  • GitHub repositoryhttps://github.com/dream-num/univer

Univer's application scenarios

  • Enterprise office automationIt enables businesses to create, edit, and share spreadsheets, documents, and presentations, improving productivity and team collaboration.
  • Data Analysis and ReportingData analysts perform complex data calculations, analysis, and report generation, particularly in the fields of finance, sales, and market research.
  • Education and ScholarshipTeachers and students can create teaching materials, course assignments, and research papers, while also supporting collaborative editing to facilitate teamwork.
  • project managementProject managers and team members plan project schedules, track tasks, and share project documents.
  • Customer Relationship Management (CRM)Businesses can integrate Univer into their CRM systems for managing and analyzing customer data.