- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- ReportSheet
- Data Charts
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- AI Assistant
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
SJS.AI.TEXTSENTIMENT
Summary
SJS.AI.TEXTSENTIMENT is a function in SpreadJS that analyzes the sentiment of text in cells and returns Positive, Negative, or Neutral results.
This feature is useful for:
Customer review analysis
Social media sentiment monitoring
Product feedback classification
Other text sentiment analysis scenarios
Syntax
=SJS.AI.TEXTSENTIMENT(array, positive, negative, [neutral])Arguments
Parameter | Description |
|---|---|
array Required | The input text or a cell reference containing the text to analyze (e.g., |
positive Required | The value returned if the sentiment is Positive. |
negative Required | The value returned if the sentiment is Negative. |
neutral Optional | The value returned if the sentiment is Neutral. If omitted, it may return a blank. |
Remarks:
SJS.AI.TEXTSENTIMENT is an asynchronous formula that will return #BUSY! during the analysis process.
Examples
Assume B2:B4 contains customer reviews, and we want to classify them as Good Review, Bad Review, or Neutral Review.
=SJS.AI.TEXTSENTIMENT(B2:B4, "Good Review", "Bad Review", "Neutral Review")