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

New-OfficeExcelOpenDocumentOptions

Module
PSWriteOffice
Inputs
None
Outputs
OfficeIMO.Excel.OpenDocument.ExcelOpenDocumentConversionOptions
Source
NewOfficeExcelOpenDocumentOptionsCommand.cs:16 Edit on GitHub

Creates Excel/OpenDocument conversion settings.

Syntax

New-OfficeExcelOpenDocumentOptions
[-IncludeBasicStyles]
[-LossPolicy <ReportOnly|ThrowOnSkippedOrUnsupported|ThrowOnAnyLoss>]
[-MaximumColumns <Int32>]
[-MaximumExpandedCells <Int64>]
[-MaximumRows <Int32>]
[<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Convert a bounded worksheet area with basic styles.

$options = New-OfficeExcelOpenDocumentOptions -IncludeBasicStyles -MaximumRows 10000 -MaximumColumns 100
ConvertTo-OfficeOpenDocument -Path .\Data.xlsx -OutputPath .\Data.ods -ExcelOptions $options

Parameters

-IncludeBasicStyles SwitchParameter optional
Copy common font, fill, and number-format styles.
-LossPolicy OdfConversionLossPolicy optional
Whether conversion loss is reported or rejected.
Possible values: ReportOnly, ThrowOnSkippedOrUnsupported, ThrowOnAnyLoss
-MaximumColumns Int32 optional
Maximum spreadsheet columns.
-MaximumExpandedCells Int64 optional
Maximum cells materialized during conversion.
-MaximumRows Int32 optional
Maximum spreadsheet rows.

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.