Cmdlet
Copy-OfficeExcelWorkbook
Copies a workbook package while preserving package parts.
Syntax
Copy-OfficeExcelWorkbook
[-DestinationPath] <String>
[-Force]
[-PassThru]
[-Path] <String>
[<CommonParameters>]#Parameter set:
All Parameter SetsExamples
Copy a workbook package and return the copied file.
$copy = Copy-OfficeExcelWorkbook -Path .\Template.xlsx -DestinationPath .\Report.xlsx -Force -PassThru
Test-OfficeExcelWorkbook -Path $copy.FullName -SkipOpenXmlValidation |
Select-Object Passed, WorksheetCountCopies the workbook package and normalizes the workbook content type for the destination extension.
Parameters
- -DestinationPath String
- Destination workbook path.
- -Force SwitchParameter
- Replace an existing destination workbook.
- -PassThru SwitchParameter
- Emit a FileInfo for the copied workbook.
- -Path String
- Source workbook or template package 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.