# New-OfficeExcelOpenDocumentOptions

Creates Excel/OpenDocument conversion settings. Review available syntax, parameters, pipeline guidance, and reference details in PSWriteOffice Cmdlet Reference.

Cmdlet 

**Module**

`PSWriteOffice`

**Inputs**

`None`

**Outputs**

`OfficeIMO.Excel.OpenDocument.ExcelOpenDocumentConversionOptions`

**Source**

[NewOfficeExcelOpenDocumentOptionsCommand.cs:16](https://github.com/EvotecIT/OfficeIMO/blob/3b680b1b6fb15a268ff5525a4ca6cdd70b2f6613/PowerShell/PSWriteOffice/Sources/PSWriteOffice/Cmdlets/OpenDocument/NewOfficeExcelOpenDocumentOptionsCommand.cs#L16) 

Creates Excel/OpenDocument conversion settings.

## Syntax

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

[#](#method-new-officeexcelopendocumentoptions-switchparameter-odfconversionlosspolicy-int32-int64-int32)

Parameter set: `Default`

## Guides & Samples

Authored walkthroughs and practical samples linked to this command.

- [Open Formats and Text Automation](/docs/pswriteoffice/open-text-formats/) Guide
  
  Use the smaller PSWriteOffice families for text, interchange, open formats, and managed message workflows. Includes examples and cmdlet links.
- [Convert OpenDocument to and from Office](/docs/open-document/convert-office/) Guide
  
  Convert ODT to DOCX, ODS to XLSX and ODP to PPTX and back, and read the per-feature report of what was mapped, approximated or lost.

## Examples

### Convert a bounded worksheet area with basic styles.

```powershell
$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](https://learn.microsoft.com/powershell/module/microsoft.powershell.core/about/about_commonparameters).

<!-- PowerForge markdown artifact sha256:0D4D44A240B2268D63864EEBB7003667FF1EB39A64573A686D60E596448086F7 -->
