New-OfficeExcelOpenDocumentOptions

Namespace PSWriteOffice

Inputs

None

Outputs

OfficeIMO.Excel.OpenDocument.ExcelOpenDocumentConversionOptions

Source

Sources/PSWriteOffice/Cmdlets/OpenDocument/NewOfficeExcelOpenDocumentOptionsCommand.cs:16 Edit on GitHub

Creates Excel/OpenDocument conversion settings.

Remarks

Creates Excel/OpenDocument conversion settings.

Examples

Authored help example

Convert a bounded worksheet area with basic styles.

PS>


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

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

New-OfficeExcelOpenDocumentOptions [-IncludeBasicStyles] [-LossPolicy <ReportOnly|ThrowOnSkippedOrUnsupported|ThrowOnAnyLoss>] [-MaximumColumns <Int32>] [-MaximumExpandedCells <Int64>] [-MaximumRows <Int32>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

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

Outputs

OfficeIMO.Excel.OpenDocument.ExcelOpenDocumentConversionOptions