AI Assist Integration in ASP.NET Core Spreadsheet control

11 Jun 202612 minutes to read

Integration

AI Assist integrates seamlessly into your ASP.NET Core Spreadsheet application, enabling AI-powered capabilities with minimal configuration. This section covers the required setup.

Prerequisites

Ensure the following before integrating AI Assist:

  • Backend Server: A running backend AI service (Node.js or Web API) with AI credentials configured on the server.
  • For setup instructions, see the:

Add CSS references

Add the following AI Assist dependent style references to the <head> section of ~/Pages/Shared/_Layout.cshtml.

```html
<head>
    ...
    <link rel="stylesheet" href="https://cdn.syncfusion.com/ej2/34.1.29/ej2-notifications/styles/fluent.css" />
    <link rel="stylesheet" href="https://cdn.syncfusion.com/ej2/34.1.29/ej2-interactive-chat/styles/fluent.css" />
</head>
```

Inject the AI Assist Module

Inject the AIAssist module into the Spreadsheet using JavaScript. Add the following script after the Syncfusion script references in ~/Pages/Shared/_Layout.cshtml.

```html
<script>
    ej.spreadsheet.Spreadsheet.Inject(ej.spreadsheet.AIAssist);
</script>
```

Enable AI Assist

To enable AIAssist in the Spreadsheet tag helper, set the enableAIAssist property to true.

```cshtml
<ejs-spreadsheet id="spreadsheet" enableAIAssist="true"
    openUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/open"
    saveUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/save">
</ejs-spreadsheet>
```

This enables the AI Assist into the spreadsheet.

Configure AI Assist Settings

Use the aiAssistSettings property to connect the spreadsheet to the backend server and customize the AI Assist.

```cshtml
<ejs-spreadsheet id="spreadsheet" enableAIAssist="true"
    openUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/open"
    saveUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/save">
    <e-spreadsheet-aiassistsettings
        requestUrl="https://localhost:{port}/api/AIAssist/Chat"
        placeholder="Ask the AI about this sheet..."
        promptSuggestions="@(new string[] { "Your suggestions" })">
    </e-spreadsheet-aiassistsettings>
</ejs-spreadsheet>
```

Your Spreadsheet is now integrated with AI Assist and ready to use.

How-To Guides

Open and Close the AI Panel

  • Open: Click the AI Assist button in the ribbon toolbar.
  • Close: Click the ✕ button inside the panel header, or click the AI Assist ribbon button again.
  • Start new conversation.: Click the ↺ (Refresh) button in the panel header.
  • Resize the panel: Drag the left edge of the panel to make it wider or narrower.

Undo an AI Action

All actions performed by AI Assist are recorded in the spreadsheet’s undo/redo history. Press Ctrl+Z to revert any change made by the AI, just like a manual edit.

How to Customize the Request Before Sending

Use the promptRequest event to add custom data — such as a user ID or session token — to the request before it reaches your server.

```cshtml
<ejs-spreadsheet id="spreadsheet" enableAIAssist="true" promptRequest="onPromptRequest"
    openUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/open"
    saveUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/save">
    <e-spreadsheet-aiassistsettings requestUrl="https://localhost:{port}/api/AIAssist/Chat">
    </e-spreadsheet-aiassistsettings>
</ejs-spreadsheet>

<script>
    function onPromptRequest(args) {
        if (args.requestData) {
            args.requestData.body.userId = 'your-user-id';
        }
    }
</script>
```

You can also prevent the request entirely by setting args.cancel = true.

How to Handle AI Responses

Use the promptResponse event to run custom logic after the AI completes its task — for example, logging results or showing a notification.

```cshtml
<ejs-spreadsheet id="spreadsheet" enableAIAssist="true" promptResponse="onPromptResponse"
    openUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/open"
    saveUrl="https://document.syncfusion.com/web-services/spreadsheet-editor/api/spreadsheet/save">
    <e-spreadsheet-aiassistsettings requestUrl="https://localhost:{port}/api/AIAssist/Chat">
    </e-spreadsheet-aiassistsettings>
</ejs-spreadsheet>

<script>
    function onPromptResponse(args) {
        console.log('AI Response received:', args.response);
    }
</script>
```

Troubleshoot server connection issues

If the AI panel displays an error message:

  1. Verify the server is running
    • Confirm your Node.js or Web API server is active
    • Check the console for startup messages
  2. Check the requestUrl
    • Ensure the URL matches your server’s exact address and port
    • For local development:
      • Node.js: http://localhost:3000/api/AIAssist/Chat
      • Web API (.NET): https://localhost:5001/api/AIAssist/Chat
  3. Verify CORS is enabled
    • Your ASP.NET Core application origin must be allowed in the AI server’s CORS policy
    • Default ASP.NET Core dev server: https://localhost:{port} (as defined in launchSettings.json)
  4. Use browser DevTools
    • Open the Network tab to inspect failed requests
    • Check for 404, 500, or CORS errors
    • Look at the response body for error details
  5. Check server logs
    • Review the terminal/console where your server is running
    • Look for connection or authentication errors

API References

AI Assist Settings

Property Type Description
requestUrl string The URL of your AI server endpoint. All prompts are sent here.
placeholder string The hint text shown inside the prompt input box.
promptSuggestions string[] A list of quick-start prompts shown to the user as clickable suggestions.

Events

Event When it fires Common use
promptRequest Before the prompt is sent to the server Attach extra data or cancel the request
promptResponse After the AI completes and responds Log results or trigger custom UI updates

What Can You Ask the AI?

Type your request in plain English — no formulas or technical knowledge needed.

Data Analysis

What to say What it does
“Can you give me a summary of this sheet?” Reviews your data and highlights key trends and totals
“What are the top 5 rows by sales?” Picks out the highest-performing records from your data
“Generate a full report for this sheet” Creates a structured report with KPIs, top records, and chart suggestions

Data Operations

What to say What it does
“Change the value in A1 to 500” Updates cell A1 with the new value
“Fill in the dates for the rest of the column” Continues a date or number pattern using AutoFill
“Swap ‘Shoes’ with ‘Footwear’ everywhere in this sheet” Finds and replaces the text throughout the entire sheet

Formatting

What to say What it does
“Make the header row bold with a blue background” Applies bold text and blue fill to your header cells
“Show the prices in currency format” Formats the selected cells to display as currency
“Make the text italic and red in column C” Applies italic style and red font color to the column
“Make the text fit inside the cells in column D” Turns on text wrapping so long text does not overflow

Rules & Validation

What to say What it does
“Highlight any values above 1000 in green” Applies a conditional formatting rule to flag high values
“Mark duplicate values in column A with a red background” Colors cells that appear more than once
“Only allow values between 1 and 100 in column B” Adds a data validation rule to restrict input
“Add a dropdown list with Yes and No options to column C” Creates a dropdown for easy, consistent data entry

Structure Management

What to say What it does
“Add two blank rows above row 5” Inserts two new rows at that position
“Remove column C” Deletes the entire column from the sheet
“Combine cells A1 to C1 into one” Merges the range into a single cell
“Keep the first two rows visible when I scroll down” Freezes the top rows so they stay in place
What to say What it does
“Sort the data by sales from highest to lowest” Reorders rows based on the sales column, descending
“Show me only the rows where the region is India” Applies a filter so only matching rows are visible
“Find all cells that say ‘Pending’ and change them to ‘Done’” Runs a find and replace across the sheet

Clipboard Actions

What to say What it does
“Copy the data from A1 to B5 and put it at D1” Copies the range and pastes it at the new location
“Move the content from A1:B3 to E1” Cuts the range and pastes it to the destination

Visualization

What to say What it does
“Create a bar chart from my sales data” Inserts a bar chart based on the selected data range
“Add a line chart showing the monthly trend” Creates a line chart to visualize changes over time
“Insert a pie chart with a title called ‘Revenue Split’” Creates a pie chart with a custom title

See also