Join-OfficeExcelWorkbook

Examples

Merge workbook sheets using the package fast path.

PS>

$sources = Get-ChildItem .\Incoming\*.xlsx | Select-Object -ExpandProperty FullName
            $results = Join-OfficeExcelWorkbook -Path .\Combined.xlsx -SourcePath $sources -CopyMode Package -SheetNamePrefix Import
            $results | Select-Object SheetCount, SourceSheets, TargetSheets
        

Copies worksheets between packages without importing rows into PowerShell objects, which is the preferred path for large workbook merge workflows.

Import selected source sheets with a prefix.

PS>

$merge = Join-OfficeExcelWorkbook -Path .\Target.xlsx -SourcePath .\Source.xlsx -SourceSheet Data,Summary -SheetNamePrefix 'Imported '
            Get-OfficeExcelSummary -Path .\Target.xlsx |
                Select-Object Path, WorksheetCount
        

Copies selected worksheets from Source.xlsx into Target.xlsx using OfficeIMO workbook merge logic.