Apache POI · Schema

Cell

Individual Excel cell

Document ProcessingExcelJavaMicrosoft OfficePowerPointWordApacheOpen Source

Properties

Name Type Description
address string Cell address (e.g. A1)
value string Cell value as string
type string Cell type
formula string Formula if applicable
View JSON Schema on GitHub

JSON Schema

apache-poi-cell-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/apache-poi/refs/heads/main/json-schema/apache-poi-cell-schema.json",
  "title": "Cell",
  "description": "Individual Excel cell",
  "type": "object",
  "properties": {
    "address": {
      "type": "string",
      "description": "Cell address (e.g. A1)"
    },
    "value": {
      "type": "string",
      "description": "Cell value as string"
    },
    "type": {
      "type": "string",
      "enum": [
        "STRING",
        "NUMERIC",
        "BOOLEAN",
        "FORMULA",
        "BLANK",
        "ERROR"
      ],
      "description": "Cell type"
    },
    "formula": {
      "type": "string",
      "description": "Formula if applicable"
    }
  }
}