Add AI Formula Help to JavaScript Apps

SpreadJS is a complete enterprise JavaScript spreadsheet solution used to create financial reports and dashboards, budgeting and forecasting models, scientific, engineering, healthcare, education, science lab notebooks, and other similar JavaScript business applications. It delivers true Excel-like spreadsheet experiences with zero dependencies on Excel, with full support for React, Vue, Angular, and TypeScript.

In this blog post, MESCIUS Product Manager Chris Bannon shows you how to connect the SpreadJS AI Assistance add-on to a custom-trained Ollama model so it can generate and explain application-specific spreadsheet formulas without requiring you to manually unpack every function, reference, and operator. Steps include:

• Create the Custom Spreadsheet Function
• Put the Function in a Real Workbook Context
• Add the Formula Editor Panel and AI Assistant Add-on
• Connect SpreadJS AI to Your Own Endpoint
• Teach the Model About the Custom Formula
• Create the Local Ollama Model

Detailed code is included to help you along the way.

Read the complete blog and get started unlocking the power of the SpreadJS AI Assistant.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.