Cmdlet

ConvertTo-OfficeExcelWorkbook

Module PSWriteOffice

Inputs

None

Outputs

System.IO.FileInfo

Source

ConvertToOfficeExcelWorkbookCommand.cs:26 Edit on GitHub

Converts Excel workbooks between supported .xls and .xlsx formats.

Syntax

ConvertTo-OfficeExcelWorkbook [-AllowLossyLegacyConversion] [-Force] [-Open] [-OutputPath] <String> [-PassThru] [-Path] <String> [<CommonParameters>]

Parameter set: All Parameter Sets

Description

Uses the OfficeIMO Excel normal load/save conversion path, including legacy XLS diagnostics and save preflight.

Examples

Authored help example

Convert a legacy XLS file to XLSX.

ConvertTo-OfficeExcelWorkbook -Path .\legacy.xls -OutputPath .\converted.xlsx -PassThru

Reads the .xls file and writes a .xlsx workbook.

Convert an XLSX workbook to native XLS.

ConvertTo-OfficeExcelWorkbook -Path .\report.xlsx -OutputPath .\report.xls -Force

Writes a supported native BIFF8 .xls workbook.

Parameters

-AllowLossyLegacyConversion SwitchParameter optional: Allow conversion when a legacy XLS source contains unsupported or preserve-only content.
-Force SwitchParameter optional: Overwrite an existing destination file.
-Open SwitchParameter optional: Open the converted workbook after saving.
-OutputPath String requiredposition: 1aliases: OutPath: Destination .xls or .xlsx file path.
-PassThru SwitchParameter optional: Emit the saved file information.
-Path String requiredposition: 0aliases: FilePath: Source .xls or .xlsx file path.

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.