Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 05 / xlsx structured table reference union intersection cell set

Materialize dependency cells selected by structured spreadsheet table references and reference operators.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-05/xlsx-structured-table-reference-union-intersection-cell-set

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
artifactobjectJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "artifact"
  ],
  "properties": {
    "artifact": {
      "type": "object",
      "additionalProperties": false,
      "required": [
        "spreadsheetReferences"
      ],
      "properties": {
        "spreadsheetReferences": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "tables",
                "nodes",
                "root",
                "current_row"
              ],
              "properties": {
                "tables": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "name",
                      "row",
                      "column",
                      "columns",
                      "data_rows",
                      "header",
                      "totals"
                    ],
                    "properties": {
                      "name": {
                        "type": "string",
                        "maxLength": 64,
                        "minLength": 1
                      },
                      "row": {
                        "type": "integer",
                        "minimum": 1,
                        "maximum": 10000
                      },
                      "column": {
                        "type": "integer",
                        "minimum": 1,
                        "maximum": 1000
                      },
                      "columns": {
                        "type": "array",
                        "items": {
                          "type": "string",
                          "maxLength": 64,
                          "minLength": 1
                        },
                        "maxItems": 32,
                        "minItems": 1
                      },
                      "data_rows": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 64
                      },
                      "header": {
                        "type": "boolean"
                      },
                      "totals": {
                        "type": "boolean"
                      }
                    }
                  },
                  "maxItems": 16,
                  "minItems": 1
                },
                "nodes": {
                  "type": "array",
                  "items": {
                    "anyOf": [
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "name",
                          "first_column",
                          "last_column",
                          "items"
                        ],
                        "properties": {
                          "kind": {
                            "const": "table"
                          },
                          "name": {
                            "type": "string",
                            "maxLength": 64,
                            "minLength": 1
                          },
                          "first_column": {
                            "type": "string",
                            "maxLength": 64,
                            "minLength": 0
                          },
                          "last_column": {
                            "type": "string",
                            "maxLength": 64,
                            "minLength": 0
                          },
                          "items": {
                            "type": "array",
                            "items": {
                              "enum": [
                                "all",
                                "data",
                                "headers",
                                "totals",
                                "this_row"
                              ]
                            },
                            "maxItems": 3,
                            "minItems": 1
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "left",
                          "right"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "union",
                              "intersection"
                            ]
                          },
                          "left": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 63
                          },
                          "right": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 63
                          }
                        }
                      }
                    ]
                  },
                  "maxItems": 64,
                  "minItems": 1
                },
                "root": {
                  "type": "integer",
                  "minimum": 0,
                  "maximum": 63
                },
                "current_row": {
                  "type": "integer",
                  "minimum": 1,
                  "maximum": 10000
                }
              }
            },
            "claim": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "object",
                  "additionalProperties": false,
                  "required": [
                    "cell_count",
                    "cells"
                  ],
                  "properties": {
                    "cell_count": {
                      "type": "integer",
                      "minimum": 0,
                      "maximum": 1000000
                    },
                    "cells": {
                      "type": "array",
                      "maxItems": 2048,
                      "items": {
                        "type": "array",
                        "minItems": 2,
                        "maxItems": 2,
                        "items": {
                          "type": "integer",
                          "minimum": 1,
                          "maximum": 11000
                        }
                      }
                    }
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

Originalschema öffnen

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →