Help for this page

Select Code to Download

Select or download this

$sheet->Cells(10,5)->PasteSpecial(
  {Paste => xlAll,
...
   SkipBlanks =>  0,
   Transpose => 1
  });

Select or download this

$sheet->Cells(10,5)->PasteSpecial(xlAll, xlNone,  0, 1);