Excel计算助手-COZE插件使用详解
Excel计算插件 - 详细输入输出示例（对象数组格式）
需要使用coze插件市场直接搜索Excel计算插件
所有示例基于以下对象数组数据：
[
{"product_name": "笔记本电脑", "price": 5000, "sales": 120, "revenue": 600000, "department": "电子产品"},
{"product_name": "台式电脑", "price": 4000, "sales": 80, "revenue": 320000, "department": "电子产品"},
{"product_name": "显示器", "price": 1500, "sales": 200, "revenue": 300000, "department": "电子产品"},
{"product_name": "键盘鼠标", "price": 300, "sales": 500, "revenue": 150000, "department": "配件"},
{"product_name": "音响设备", "price": 800, "sales": 150, "revenue": 120000, "department": "电子产品"}
]
字段说明：
- `product_name` - 产品名称
- `price` - 单价
- `sales` - 销量
- `revenue` - 销售额
- `department` - 部门
1、求和计算 (sum)
输入
{
"operation": "sum",
"data": [
{"product_name": "笔记本电脑", "revenue": 600000},
{"product_name": "台式电脑", "revenue": 320000},
{"product_name": "显示器", "revenue": 300000},
{"product_name": "键盘鼠标", "revenue": 150000},
{"product_name": "音响设备", "revenue": 120000}
],
"column": "revenue"
}
输出
{
"success": true,
"operation": "sum",
"column": "revenue",
"result": 1490000.0,
"valid_count": 5
}
说明： 计算所有产品的销售额总和 = 600000 + 320000 + 300000 + 150000 + 120000 = 1490000
2、平均值计算 (average)
输入
{
"operation": "average",
"data": [
{"product_name": "笔记本电脑", "price": 5000},
{"product_name": "台式电脑", "price": 4000},
{"product_name": "显示器", "price": 1500},
{"product_name": "键盘鼠标", "price": 300},
{"product_name": "音响设备", "price": 800}
],
"column": "price"
}
输出
{
"success": true,
"operation": "average",
"column": "price",
"result": 2320.0,
"valid_count": 5
}
说明： 平均单价 = (5000 + 4000 + 1500 + 300 + 800) / 5 = 2320
3、最大值查询 (max)
输入
{
"operation": "max",
"data": [
{"product_name": "笔记本电脑", "sales": 120},
{"product_name": "台式电脑", "sales": 80},
{"product_name": "显示器", "sales": 200},
{"product_name": "键盘鼠标", "sales": 500},
{"product_name": "音响设备", "sales": 150}
],
"column": "sales"
}
输出
{
"success": true,
"operation": "max",
"column": "sales",
"result": 500.0
}
说明：最高销量 = 500（键盘鼠标的销量最高）
4、最小值查询 (min)
输入
{
"operation": "min",
"data": [
{"product_name": "笔记本电脑", "price": 5000},
{"product_name": "台式电脑", "price": 4000},
{"product_name": "显示器", "price": 1500},
{"product_name": "键盘鼠标", "price": 300},
{"product_name": "音响设备", "price": 800}
],
"column": "price"
}
输出
{
"success": true,
"operation": "min",
"column": "price",
"result": 300.0
}
说明： 最低单价 = 300（键盘鼠标的单价最低）
5、行数统计 (count)
输入
{
"operation": "count",
"data": [
{"product_name": "笔记本电脑", "price": 5000, "sales": 120},
{"product_name": "台式电脑", "price": 4000, "sales": 80},
{"product_name": "显示器", "price": 1500, "sales": 200},
{"product_name": "键盘鼠标", "price": 300, "sales": 500},
{"product_name": "音响设备", "price": 800, "sales": 150}
]
}
输出
{
"success": true,
"operation": "count",
"result": 5
}
说明： 总共有5条数据记录
7、数据筛选 (filter)
7.1 等于筛选
输入
{
"operation": "filter",
"data": [
{"product_name": "笔记本电脑", "price": 5000, "sales": 120, "revenue": 600000, "department": "电子产品"},
{"product_name": "台式电脑", "price": 4000, "sales": 80, "revenue": 320000, "department": "电子产品"},
{"product_name": "显示器", "price": 1500, "sales": 200, "revenue": 300000, "department": "电子产品"},
{"product_name": "键盘鼠标", "price": 300, "sales": 500, "revenue": 150000, "department": "配件"},
{"product_name": "音响设备", "price": 800, "sales": 150, "revenue": 120000, "department": "电子产品"}
],
"column": "department",
"condition": "equals",
"value": "电子产品"
}
输出
{
"success": true,
"operation": "filter",
"filtered_count": 4,
"original_count": 5,
"data": [
{"product_name": "笔记本电脑", "price": 5000, "sales": 120, "revenue": 600000, "department": "电子产品"},
{"product_name": "台式电脑", "price": 4000, "sales": 80, "revenue": 320000, "department": "电子产品"},
{"product_name": "显示器", "price": 1500, "sales": 200, "revenue": 300000, "department": "电子产品"},
{"product_name": "音响设备", "price": 800, "sales": 150, "revenue": 120000, "department": "电子产品"}
]
}
说明：筛选出部门等于"电子产品"的4条记录
7.3 大于筛选
输入
{
"operation": "filter",
"data": [
{"product_name": "笔记本电脑", "sales": 120},
{"product_name": "台式电脑", "sales": 80},
{"product_name": "显示器", "sales": 200},
{"product_name": "键盘鼠标", "sales": 500},
{"product_name": "音响设备", "sales": 150}
],
"column": "sales",
"condition": "greater_than",
"value": "100"
}
输出
{
"success": true,
"operation": "filter",
"filtered_count": 4,
"original_count": 5,
"data": [
{"product_name": "笔记本电脑", "sales": 120},
{"product_name": "显示器", "sales": 200},
{"product_name": "键盘鼠标", "sales": 500},
{"product_name": "音响设备", "sales": 150}
]
}
说明：筛选出销量大于100的4条记录（台式电脑销量80被排除）
7.3 小于筛选
输入
{
"operation": "filter",
"data": [
{"product_name": "笔记本电脑", "price": 5000},
{"product_name": "台式电脑", "price": 4000},
{"product_name": "显示器", "price": 1500},
{"product_name": "键盘鼠标", "price": 300},
{"product_name": "音响设备", "price": 800}
],
"column": "price",
"condition": "less_than",
"value": "1000"
}
输出
{
"success": true,
"operation": "filter",
"filtered_count": 2,
"original_count": 5,
"data": [
{"product_name": "键盘鼠标", "price": 300},
{"product_name": "音响设备", "price": 800}
]
}
说明：筛选出单价小于1000的2条记录
7.3 包含筛选
输入
{
"operation": "filter",
"data": [
{"product_name": "笔记本电脑", "price": 5000},
{"product_name": "台式电脑", "price": 4000},
{"product_name": "显示器", "price": 1500},
{"product_name": "键盘鼠标", "price": 300},
{"product_name": "音响设备", "price": 800}
],
"column": "product_name",
"condition": "contains",
"value": "电脑"
}
输出
{
"success": true,
"operation": "filter",
"filtered_count": 2,
"original_count": 5,
"data": [
{"product_name": "笔记本电脑", "price": 5000},
{"product_name": "台式电脑", "price": 4000}
]
}
说明： 筛选出产品名称包含"电脑"的2条记录（不区分大小写）
错误示例
错误输入：列名不存在
输入
{
"operation": "sum",
"data": [
{"product_name": "笔记本电脑", "price": 5000, "sales": 120}
],
"column": "不存在的列"
}
输出
{
"success": false,
"error": "列'不存在的列'不存在"
}
使用建议
1. 数据格式 - data使用对象数组格式，每个对象包含所有字段
2. 列名必须存在 - 确保列名与数据中的键名完全一致
3. 数据类型 - 数值列自动识别，文本列使用equals/contains筛选
4. 检查结果 - 始终检查 `success` 字段确认操作是否成功
5. 筛选返回 - filter操作返回完整的对象数组，包含所有字段
🔄 数据格式说明
对象数组格式（推荐）：
[
{"product_name": "商品A", "price": 100, "sales": 50},
{"product_name": "商品B", "price": 150, "sales": 30}
]
优势：
- 更直观，按列名访问
- 无需额外参数
- 更符合JSON习惯
- 易于理解和维护
中国智能体开发者社区，聚焦智能体与大模型开发，提供前沿资讯、实用工具链、开源项目及行业案例。通过技术沙龙、开发者大赛等活动，促进经验交流与协作，助力开发者快速构建创新智能应用。
更多推荐
12
0- 0
已为社区贡献1条内容
所有评论(0)