Example of Smart Spreadsheet in ASP.NET MVC Spreadsheet Control
This demo showcases the AI Assist integration in Syncfusion Spreadsheet React sample, enabling users to interact with their data more efficiently. Users can perform a wide range of spreadsheet operations-such as formatting data, generating insights, creating charts, sorting & filtering, and summarizing using simple prompts.
This sample demonstrates the Built-in AI Assist functionality in the Spreadsheet component, enabling users to perform a wide range of spreadsheet tasks seamlessly.
The AI Assist capability includes chat-based interaction with prompt suggestions and support for a resizable layout. All actions triggered through AI are executed directly in the spreadsheet with undo/redo support, providing a seamless and intuitive user experience.
How AI Assist Works
- When a user submits a prompt in the AI Assist panel, the request is sent to the AI service, where the prompt is processed to interpret the user's intent and determine the required operation (such as editing, formatting, reporting, or data analysis).
- Based on the interpreted actions, the system sends the action-specific data along with the current spreadsheet context to the AI service to generate relevant, executable commands.
- The AI service processes this information and returns structured commands, which are then executed directly in the spreadsheet (such as updating cells, applying styles, inserting charts, or reorganizing data).
- Changes are immediately reflected in the Spreadsheet UI, and a confirmation is displayed in the AI Assist panel.
Key Capabilities:
- Data Analysis: Generate insights including summaries, KPIs, top records, and visual suggestions.
- Data Operations: Edit cell values, apply AutoFill and manage content.
- Rules & Validation: Apply conditional formatting and data validation rules.
- Formatting: Apply styles such as bold, italic, font color, background color, number formats, and wrap text.
- Structure Management: Insert/delete rows and columns, merge cells, and freeze panes.
- Clipboard Actions: Perform cut, copy, and paste operations through AI commands.
- Navigation: Perform sorting, filtering, and find & replace operations.
- Visualization: Insert charts with multiple types, themes, titles, and sizing options.
AI Assist can be enabled by injecting the AIAssist module into the Spreadsheet using the Inject method and setting the enableAIAssist property to true.
Configure AI Assist behaviors using the aiAssistSettings property:
- requestUrl - Endpoint for your AI service.
- placeholder - Placeholder text for the input area.
- promptSuggestions - Predefined prompts to guide user interaction.
More information about the AI Assist feature can be found in this documentation section.