Project

PSWriteOffice

PowerShell document automation across OfficeIMO's document, spreadsheet, presentation, PDF, Project, Access, EPUB, invoicing, and conversion engines.

View on GitHub Releases Get package
Stars 654
Forks 82
Open issues 1
Total downloads 4,320,051
Release OfficeIMO-v3.5.3
Language: C# Updated: 2026-11-03
Cmdlet

Set-OfficeOpenDocumentCell

Module
PSWriteOffice
Inputs
OfficeIMO.OpenDocument.OdsSheet
Outputs
OfficeIMO.OpenDocument.OdsCell
Source
SetOfficeOpenDocumentCellCommand.cs:17 Edit on GitHub

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

Syntax

Set-OfficeOpenDocumentCell
-Column <Int64>
[-PassThru]
-Row <Int64>
[-Sheet <OdsSheet>]
[-Value] <Object>
[<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Set typed values inside the active worksheet.

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.