I finally got it. The correct code is

$sheet->PageSetup->{PrintTitleRows} = ($sheet->Rows('$1:$2')->Address)
+;
[download]

Thanks for the help. Now on to adding page breaks.

Janitored by Corion: Added closing code tag, as per Writeup Formatting Tips