in reply to Win32::OLE: how to modify a range of values in an excel table

Try
$worksheet->Range("B5:C6")->{Value} = \@matrix; #####################################^^^