# Set-OfficeOpenDocumentCell

Sets a typed zero-based cell value in an OpenDocument spreadsheet.

Cmdlet 

Aliases: OpenDocumentCell

**Module**

`PSWriteOffice`

**Aliases**

`OpenDocumentCell`

**Inputs**

`OfficeIMO.OpenDocument.OdsSheet`

**Outputs**

`OfficeIMO.OpenDocument.OdsCell`

**Source**

[SetOfficeOpenDocumentCellCommand.cs:17](https://github.com/EvotecIT/OfficeIMO/blob/3b680b1b6fb15a268ff5525a4ca6cdd70b2f6613/PowerShell/PSWriteOffice/Sources/PSWriteOffice/Cmdlets/OpenDocument/SetOfficeOpenDocumentCellCommand.cs#L17) 

Sets a typed zero-based cell value in an OpenDocument spreadsheet.

## Syntax

```
Set-OfficeOpenDocumentCell
-Column <Int64>
[-PassThru]
-Row <Int64>
[-Sheet <OdsSheet>]
[-Value] <Object>
[<CommonParameters>]
```

[#](#method-set-officeopendocumentcell-int64-switchparameter-int64-odssheet-object)

Parameter set: `Default`

## Guides & Samples

Authored walkthroughs and practical samples linked to this command.

- [Open Formats and Text Automation](/docs/pswriteoffice/open-text-formats/) Guide
  
  Use the smaller PSWriteOffice families for text, interchange, open formats, and managed message workflows. Includes examples and cmdlet links.
- [Create and Read ODT, ODS and ODP Files](/docs/open-document/create-read/) Guide
  
  Create OpenDocument text, spreadsheet and presentation files, read their content, edit them in place, and open password-protected files.

## Examples

### Set typed values inside the active worksheet.

```powershell
Set-OfficeOpenDocumentCell -Row 0 -Column 0 -Value 'Healthy'
Set-OfficeOpenDocumentCell -Row 0 -Column 1 -Value $true
```

## Parameters

**-Column Int64 required**

Zero-based column index.

**-PassThru SwitchParameter optional**

Emit the updated cell.

**-Row Int64 required**

Zero-based row index.

**-Sheet OdsSheet optionalpipeline: True (ByValue)**

Worksheet target. Omit inside Add-OfficeOpenDocumentSheet -Content.

**-Value Object requiredposition: 0**

String, number, decimal, boolean, date, date-time offset, or time span value.

## Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see [about_CommonParameters](https://learn.microsoft.com/powershell/module/microsoft.powershell.core/about/about_commonparameters).

<!-- PowerForge markdown artifact sha256:E1B4F4220F1992DE8FF5BA5AFCEDC41758F2797330681C89E13E2368F21014CF -->
