GuardMarket

csv.escape_formulas

防止表格公式注入

Prefix risky spreadsheet cells (=,+,-,@ or control/leading-whitespace variants) with an apostrophe before CSV export.

Version 1.0.0确定性数据处理Backend required

使用场景 / Purpose

Csv: escape formulas. 本技能对提供的参数执行计算,输入输出契约如下。文档例子来自已实现函数的固定验收样例;网页本身不执行代码。

输入字段 / Parameters

字段类型要求约束与说明
rows"array"必填 Required{"items": {"type": "array", "items": {"type": "string", "minLength": 0, "maxLength": 2000}, "minItems": 0, "maxItems": 100}, "minItems": 0, "maxItems": 500}

输入例子 / Example input

{
  "rows": [
    [
      "name",
      "value"
    ],
    [
      "item",
      "=1+1"
    ]
  ]
}

预期输出 / Expected output

[
  [
    "name",
    "value"
  ],
  [
    "item",
    "'=1+1"
  ]
]
完整输入 JSON Schema
{
  "type": "object",
  "properties": {
    "rows": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {
          "type": "string",
          "minLength": 0,
          "maxLength": 2000
        },
        "minItems": 0,
        "maxItems": 100
      },
      "minItems": 0,
      "maxItems": 500
    }
  },
  "required": [
    "rows"
  ],
  "additionalProperties": false,
  "maxProperties": 1000
}
完整输出 JSON Schema
{
  "type": "array",
  "items": {
    "type": [
      "object",
      "array",
      "string",
      "number",
      "boolean",
      "null"
    ],
    "maxProperties": 1000,
    "maxItems": 1000,
    "maxLength": 60000,
    "minimum": -1e+100,
    "maximum": 1e+100
  },
  "minItems": 0,
  "maxItems": 10000
}