SpreadJS AI Assistant: Formula Generation and Data Analysis

SpreadJS x AI Integration Library

Connect External AI to Transform Your Spreadsheet into an Intelligent Work Platform

SpreadJS's AI-integrated JavaScript library connects flexibly with OpenAI, Gemini, Claude, and even internal enterprise AI, letting you quickly build AI Assistant experiences on top of the familiar Excel spreadsheet interface.

It delivers a smart workflow spanning formula creation, data querying, translation, analysis, and insight extraction, all through natural language, taking user productivity and the value of your Excel data to the next level.

 ✓ Flexible AI integration support tailored to enterprise environments, including OpenAI, Gemini, Claude, and in-house LLM

SpreadJS AI Assistant Core Features

A Natural Language-Powered AI Excel Workflow, All in One Place

The SpreadJS AI Assistant enables Excel spreadsheets to understand natural language and integrate seamlessly into your business processes. From formula generation and data querying to translation, text sentiment analysis, and pivot suggestions, it delivers a consistent AI experience directly within your spreadsheet.

List of Services

    AI Formula Editor Panel

    AI Formula Editor Panel


    You can create and improve formulas within enterprise web applications using AI-based guidance with an intuitive UI. Clicking the AI button in the Formula Editor Panel opens an intelligent assistant that creates, explains, and modifies formulas in real time.

    View Demo and Code → View Document →
    Automatic Excel Formula Generation

    Automatic Excel Formula Generation


    You can easily create complex Excel formulas using natural language input. Simply enter what you want to calculate, such as "sum of amounts" or "average of sales," and the AI assistant will automatically generate a formula in the correct format.

    View Demo and Code → View Document →
    Explanation of complex formulas

    Explanation of complex formulas


    SpreadJS's AI Formula Editor analyzes all formulas you enter or select. Clicking on a query provides an easy-to-read summary of the formula's purpose, a step-by-step analysis of the logic, and explanations of the functions and arguments.

    View Demo and Code → View Document →
    AI Pivot Table Creation

    AI Pivot Table Creation


    We provide an AI Pivot Table Generation panel that simplifies pivot table creation using artificial intelligence. Instead of manually configuring fields and layouts, simply enter a common language request, such as "Display sales by car and quarter," and the AI will automatically generate a matching pivot table layout.

    View Demo and Code → View Document →
    AI Pivot Table Suggestions

    AI Pivot Table Suggestions


    The AI Pivot Table Suggestions feature automatically generates intelligent pivot table layout options to help users explore data more efficiently. Clicking the AI Suggestion button provides three recommended layouts based on your dataset.

    View Demo and Code → View Document →
    AI Analysis Panel

    AI Analysis Panel


    SpreadJS AI-Assistant's AI analytics panel adds powerful context-aware data interpretation to JavaScript pivot tables. Clicking the 'I' button provides access to an AI-based analytics interface where you can ask questions such as, "Who recorded the highest sales in the third quarter?"

    View Demo and Code → View Document →
    SJS.AI.QUERY

    SJS.AI.QUERY

    You can interact directly with AI models within the spreadsheet. By passing cell values or ranges as input, you can generate intelligent responses, perform complex data transformations, or derive insights based on existing data.

    View Demo → View Document →
    SJS.AI.TRANSLATE

    SJS.AI.TRANSLATE

    You can perform fast AI-based translation directly within the spreadsheet. By specifying the target language, this function can translate a single value or an entire array with high accuracy and natural language fluency.

    View Demo → View Document →
    SJS.AI.TEXTSENTIMENT

    SJS.AI.TEXTSENTIMENT

    It provides AI-based sentiment analysis directly into spreadsheet web apps, allowing users to instantly evaluate the tone of text data. You can apply this function to cell content to classify input as positive, negative, or neutral.

    View Demo → View Document →

    Experience the SpreadJS AI Assistant Right Now.

    Try out the AI Assistant features firsthand with a 14-day free trial and see everything it has to offer.

    SpreadJS AI Assistant Online Demo & Video

    Features available in the demo

    Everything About the SpreadJS AI Assistant

    Experience the AI Assistant features firsthand through videos and an online demo!

    • AI-powered formula generation
    • Step-by-step explanation of existing and newly generated formulas
    • AI-based pivot table layout generation
    • Pivot table analysis requests
    • SJS.AI.TRANSLATE function: Translate to a specified language
    • SJS.AI.QUERY function: Query results from an AI model
    • SJS.AI.TEXTSENTIMENT function: Return text sentiment (positive/negative/neutral)
    Go to Online Demo
    Video Thumbnail

    ▲ 동영상 썸네일을 눌러 바로 영상을 확인해 보세요.

    SpreadJS AI Assistant Quick Start Guide

    SpreadJS AI Assistant Quick Start Guide 🚀

    Follow the quick start guide to easily build a SpreadJS AI assistant feature in under 10 minutes.

    1

    NPM 패키지 설치

    SpreadJS와 AI 애드온 패키지를 설치합니다.

    터미널 
      npm install 
 @mescius/spread-sheets 
 @mescius/spread-sheets-ai-addon
    2

    서버 측 프록시 서비스 생성

    자격 증명을 보호하기 위해 클라이언트에서 직접 AI 서비스를 호출하는 대신 프록시 서비스를 호스팅해야 합니다.

    server.js 
      import 
express from 
 "express" 
;
     import 
{ OpenAI } from 
 "openai" 
;
     import 
dotenv from 
 "dotenv" 
;

    dotenv. config 
();

     const 
app = express 
();
     const 
port = process.env.PORT || 3000 
;

    app. use 
(express. json 
());
    app. use 
(express. static 
( "public" 
));

     const 
openai = new 
 OpenAI 
({
      apiKey 
: process.env.AI_API_KEY,
      baseURL 
: process.env.AI_SERVER_URL,
    });

    app. post 
( "/api/queryAI" 
, async 
(req, res) => {
      // call and handle openai.chat.completions.create(req.body) 

      // ... 

    });

    app. listen 
(port, () => {
      console. log 
( `Server is running on port 
 ${port} 
 ` 
);
    });
    3

    HTML 컨테이너 생성

    JavaScript 스프레드시트를 호스팅할 HTML 요소를 만듭니다.

    index.html 
      <!doctype html> 

     <meta 
 charset 
= "utf-8" 
 > 

     <div 
 id 
= "ss" 
 style 
= "width:100vw;height:95vh" 
 ></div> 

     <script 
 defer 
 src 
= "/client.bundle.js" 
 ></script>
    4

    클라이언트 Workbook 초기화 및 AI 주입

    SpreadJS Workbook을 초기화하고 프록시를 통해 AI를 주입합니다.

    client.js 
      import 
* as 
GC from 
 "@mescius/spread-sheets" 
;
     import 
 '@mescius/spread-sheets-ai-addon' 
;

     // SpreadJS workbook 초기화 

     const 
workbook = new 
GC.Spread.Sheets. Workbook 
( 'ss' 
);

     const 
serverCallback = async 
(requestBody) => {
      requestBody.model = 'your model name' 
;
      let 
response = await 
 fetch 
( '/api/queryAI' 
, {
        method 
: 'POST' 
,
        headers 
: { 'Content-Type' 
: 'application/json' 
},
        body 
: JSON. stringify 
(requestBody)
      });
      return 
response;
    }

     // 프록시 서비스를 사용하여 AI 주입 

    workbook. injectAI 
(serverCallback);
    🎉

    AI 기능을 더 깊이 활용해 보세요.

    Quick Start를 통해 기본적인 AI 연동을 완료했다면, 이제 SpreadJS AI 확장 기능이 제공하는 다양한 활용 시나리오와 확장 기능을 살펴볼 차례입니다.
    온라인 데모와 튜토리얼을 통해 실제 업무에 AI를 어떻게 적용할 수 있는지 확인해 보세요.

    💡 온라인 데모 바로가기 →

    🔎 도움말 문서 바로가기 →

    Frequently Asked Questions

    SpreadJS AI Assistant FAQ

    ind answers to common questions about how the SpreadJS AI Assistant uses AI and handles your data.

    Q. What is the SpreadJS AI extension feature? +

    A. It is a feature that connects SpreadJS with external AI models. Through this feature, developers can easily add and customize AI capabilities to the Excel sheet used by end users, without any complex development process.

    ⚠️ Q. Does SpreadJS provide its own AI model? +

    A. No, SpreadJS does not provide its own AI model. Instead, it offers a flexible environment where you can connect widely used AI services such as OpenAI and Gemini, or your organization's on-premise AI. Simply configure the endpoint of your preferred AI service and start using AI features directly within your web Excel app using the provided dedicated functions.

    Q. How is data security maintained when using the AI extension feature? +

    A. All data is sent directly to the external AI service or your organization's own server configured by the customer, without passing through MESCIUS servers. MESCIUS does not collect, store, or access any of this data, so you can use it with confidence.

    Diverse Enterprise Business Features Powered by SpreadJS

    Explore the Business Excel Add-Ons for SpreadJS

    SpreadJS provides Excel-based features tailored to diverse enterprise business needs, enabling fast and efficient development of even the most complex business systems.

    Excel Editor
    POPULAR

    Excel Editor

    Deliver a complete web Excel editor built on HTML5 and JavaScript to your end users.

    • Full Excel Compatibility A web editor that is fully compatible with existing Excel files.
    • Familiar UI/UX Excel menus and interface your users already know
    • Powerful Customization JS Excel library and API support for editor customization
    Learn More
    Real-Time Collaboration
    NEW

    Real-Time Collaboration

    Build an environment where multiple users can collaborate on a single sheet simultaneously.

    • Server Framework Build a stable Collaboration server based on Node.js
    • Real-Time Collaboration Multi-user simultaneous input with live user action and cursor display
    • Conflict Prevention Precise conflict control and permission management powered by OT engine
    Learn More
    Pivot Table

    Pivot Table

    Quickly summarize large volumes of Excel data and extract insights.

    • Excel-Like Experience Bring the same pivot UI and usability as Excel to the web
    • JS Control Set Custom controls for pivot UI customization
    • View Manager Save and load per-user pivot analysis views
    Learn More
    Gantt Sheet

    Gantt Sheet

    Integrate project scheduling and resource management into your Excel sheet.

    • Project Management Full support for timescales, task bars, calendars, and more
    • Data Binding Easy data binding via DataManager
    • Flexible Compatibility Import/export support based on Excel and JSON
    Learn More
    Report Sheet

    Report Sheet

    Transform complex business data into dynamic Excel reports.

    • Dynamic Reporting JSON-based data binding and automatic report generation
    • Professional Styling Consistent report layouts with precise formatting
    • Advanced Analytics Cross-sheet references and data aggregation support
    Learn More
    Data Chart

    Data Chart

    Visualize Excel data and create intuitive dashboards.

    • Dashboard Designer A dedicated designer for building Excel dashboards without coding
    • Diverse Charts Support for various Excel chart types with real-time data updates
    • Easy Binding Fast and simple JSON data connection via DataManager
    Learn More

    Ask Anything!

    Share your questions and concerns about SpreadJS with the MESCIUS expert team. We are here to listen and help.

    Online Consultation

    Introduction Inquiry

    If you need more detailed product or purchase consultation regarding SpreadJS implementation, please contact us using a method that is convenient for you.

    Experience the SpreadJS AI Assistant Right Now.

    Generate formulas, run analyses, and build pivot tables all at once using natural language.

    Use your JavaScript spreadsheet smarter with the SpreadJS AI Assistant.