Add-OfficeExcelSheet

Examples

Create a sheet named Data.

PS>

New-OfficeExcel -Path .\report.xlsx { Add-OfficeExcelSheet -Name 'Data' { ExcelCell -Address 'A1' -Value 'Region' } }
        

Creates a workbook with a worksheet named Data and writes the header “Region”.

Add a worksheet through the workbook pipeline.

PS>

$sheet = $workbook | Add-OfficeExcelSheet -Name 'Data' -PassThru
            $sheet | Set-OfficeExcelCell -Address A1 -Value 'Region'
        

Returns the worksheet so subsequent commands can target it directly.