# Batch Update Cells

> Perform Batch Update Cells through SharePoint.

Source: [https://genhealth.ai/docs/workflows/integrations/share-point/sharepoint_excel_batch_update_cells](https://genhealth.ai/docs/workflows/integrations/share-point/sharepoint_excel_batch_update_cells)

Integration: [SharePoint](https://genhealth.ai/docs/workflows/integrations/share-point.md)

- Handler: `sharepoint_excel_batch_update_cells`

- Connection type: `sharepoint`

## Inputs

- `workbook_url` — Workbook Url (expression, required)
  Required literal value or workflow expression.
- `worksheet_name` — Worksheet Name (select, required, dynamic options)
  Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
- `header_row` — Header Row (number)
  Optional numeric value.
  Default: `1`
- `headers` — Headers (expression)
  Optional literal value or workflow expression.
- `row_updates` — Row Updates (json, required)
  Required JSON value.
- `fail_on_partial` — Fail On Partial (boolean)
  Optional true-or-false value.
  Default: `true`
- `write_enabled` — Write Enabled (boolean)
  Optional true-or-false value.
  Default: `false`

## Outputs

- `success` — Success
- `submitted` — Submitted
- `write_skipped` — Write Skipped
- `skip_reason` — Skip Reason
- `workbook` — Workbook
- `row_update_count` — Row Update Count
- `updated_cells` — Updated Cells
- `failed_cells` — Failed Cells
- `failure_codes` — Failure Codes
- `error` — Error
- `error_message` — Error Message

Output schema completeness: `best_effort_declared`

## Safety

- External effect: `write`
- Confirmation recommended: no
- Retry safe: no
- Dry run supported: no

## Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

### Input schema

```json
{
  "type": "object",
  "required": [
    "workbook_url",
    "worksheet_name",
    "row_updates"
  ],
  "properties": {
    "headers": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "header_row": {
      "type": "number",
      "default": 1,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "row_updates": {
      "description": "Required JSON value.",
      "x-workflow-field-type": "json"
    },
    "workbook_url": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "write_enabled": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "worksheet_name": {
      "type": "string",
      "description": "Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.",
      "x-dynamic-options": true,
      "x-workflow-field-type": "select"
    },
    "fail_on_partial": {
      "type": "boolean",
      "default": true,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    }
  },
  "additionalProperties": false
}
```

### Output schema

```json
{
  "type": "object",
  "properties": {
    "error": {},
    "success": {},
    "workbook": {},
    "submitted": {},
    "skip_reason": {},
    "failed_cells": {},
    "error_message": {},
    "failure_codes": {},
    "updated_cells": {},
    "write_skipped": {},
    "row_update_count": {}
  },
  "additionalProperties": true
}
```