CODEWITHSUNDEEP
excelpowershell
Hatsune Yuki
Hatsune Yuki

Reputation: 75

How to Insert Cells (not Entire Row/Column) in Excel using Powershell

As the title suggested, I'm not sure how to do the equivalent of selecting only a portion of a row and insert cells (shift rows down) using Powershell. It seems like all tutorials online are about inserting the entire row or entire column which is not what I want to do.

Any ideas?

Thanks.

Upvotes: 3

Views: 2825

Answers (1)

Ansgar Wiechers
Ansgar Wiechers

Reputation: 200203

Try something like this:

$xl = New-Object -COM "Excel.Application"
$xl.Visible = $true

$wb = $xl.Workbooks.Open "C:\path\to\your.xlsx"
$ws = $wb.Sheets.Item(1)

$ws.Range("C5:E9").Insert(-4121)

Upvotes: 3

Related Questions