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

Add-OfficeOpenDocumentSheet

Module
PSWriteOffice
Inputs
OfficeIMO.OpenDocument.OdsDocument
Outputs
OfficeIMO.OpenDocument.OdsSheet
Source
AddOfficeOpenDocumentSheetCommand.cs:17 Edit on GitHub

Adds a worksheet to an OpenDocument spreadsheet and optionally runs nested cell content.

Syntax

Add-OfficeOpenDocumentSheet
[[-Content] <ScriptBlock>]
[-Document <OdsDocument>]
[-Name] <String>
[-PassThru]
[<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Add a worksheet inside an OpenDocument DSL.

Add-OfficeOpenDocumentSheet -Name 'Data' -Content {
    Set-OfficeOpenDocumentCell -Row 0 -Column 0 -Value 'Status'
}

Parameters

-Content ScriptBlock optionalposition: 1
Nested cell commands that use this worksheet as their current target.
-Document OdsDocument optionalpipeline: True (ByValue)
OpenDocument spreadsheet. Omit inside New-OfficeOpenDocument -Content.
-Name String requiredposition: 0
Worksheet name.
-PassThru SwitchParameter optional
Emit the created worksheet.

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.