Select Code to Download

Select or download this

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.
Shift Optional Variant.  Specifies which way to shift the cells.  Can 
+be one of the following XlInsertShiftDirection constants: xlShiftToRi
+ght or xlShiftDown.  If this argument is omitted, Microsoft Excel dec
+ides to do what it thinks you really want.
CopyOrigin Optional Variant. The copy origin.

Select or download this
```
$Sheet->Rows("1:13")->Insert(-4121,0);
```

Select or download this

$worksheet->Range("A3:N3")->{Value} = [
  "Point of Contact",
...
$xls->ActiveWindow->{SplitColumn}          = 3;
$xls->ActiveWindow->{FreezePanes}          = 1;

Select or download this

### build a whole bunch of data like below...
  my $defects =
...
    $dollars, $staff, $defects,
  ];
} ## end while (my $ref = $sth->fetchrow_hashref)