Paste data in a variable in an excel file

Question

I have some data in a variable in an excel file and I want to copy it to a excel file. However I am getting an error:
Exception setting "Paste": Cannot convert the "System.Object[]" value of type "Object[]" to type "Object".

$f2 = "C:\Users\This PC\Documents\testbook2.xlsx"
$xl = New-Object -ComObject Excel.Application
$xl.Visible = $true
$w2 = $xl.Workbooks.Open($f2)
$ws2 = $w2.Worksheets.Item(1)
$ws2.Paste($c)
$w2.Save()
$w2.Close()
$xl.Quit()

where $c has some data inside it.

Answer 1

Hi,

Is $c a range of cells? If $c is "some data" you can just assign the values to the cells.

Best Regards，
Ian

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

What's in $c?

The Excel paste takes two values: a destination, and a link. The destination is usually a range, and a paste takes what's been copied, not "some data", and "pastes" it into the range.
excel.worksheet.paste