Set-OfficeOpenDocumentCell

Namespace PSWriteOffice

Inputs

OfficeIMO.OpenDocument.OdsSheet

Outputs

OfficeIMO.OpenDocument.OdsCell

Source

Sources/PSWriteOffice/Cmdlets/OpenDocument/SetOfficeOpenDocumentCellCommand.cs:17 Edit on GitHub

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

Remarks

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

Examples

Authored help example

Set typed values inside the active worksheet.

PS>


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

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.

Syntax

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

Parameter set: All Parameter Sets

Parameters

Column Int64 requiredposition: namedpipeline: False: Zero-based column index.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit the updated cell.
Row Int64 requiredposition: namedpipeline: False: Zero-based row index.
Sheet OdsSheet optionalposition: namedpipeline: True (ByValue): Worksheet target. Omit inside Add-OfficeOpenDocumentSheet -Content.
Value Object requiredposition: 0pipeline: False: String, number, decimal, boolean, date, date-time offset, or time span value.

Outputs

OfficeIMO.OpenDocument.OdsCell