Copy-OfficeExcelSheet

Examples

Copy a worksheet and confirm it exists.

PS>

$proof = @(
                Copy-OfficeExcelSheet -Path .\Report.xlsx -SourceSheet Data -NewName DataCopy
                Get-OfficeExcelSummary -Path .\Report.xlsx -IncludeSheets |
                    Select-Object -ExpandProperty Sheets |
                    Where-Object Name -eq 'DataCopy'
            )
            $proof
        

Creates a copy of the Data worksheet and reads the workbook summary to verify the new tab.

Copy a worksheet from another workbook using the package fast path.

PS>

Copy-OfficeExcelSheet -Path .\Combined.xlsx -SourcePath .\Incoming.xlsx -SourceSheet RawData -NewName IncomingRaw -CopyMode Package
            Get-OfficeExcelUsedRange -Path .\Combined.xlsx -Sheet IncomingRaw
        

Copies the source worksheet package directly so large workbook merges avoid converting rows into PowerShell objects. Use CopyMode Values only when you explicitly want the reader/writer fallback.