Powershell Excel Automation
hi all, hope can help, have excel document need create new sheet there doesn't seem simple way of creating new sheet in populated excel document. there easy way of creating new sheet in document without overwriting current excel spreadsheet? the code people use following: $xl = new-object -comobject excel.application $workbook = $xl.workbooks.add() $sheet1 = $workbook.worksheets.item(1) the code overwrites current content , replaces new workbook, how can add sheet? if i'm not clear on i'm asking please ask. thanks dave this works: $workbook = $xl.workbooks.open("c:\temp\test.xls") $workbook.worksheets.add([system.reflection.missing]::value) | out-null Windows Server > Windows PowerShell ...