ArmandoG,

Are you asking how to print through Excel using OLE automation?

Although, strictly speaking this isn't a "Perl" solution, may I suggest the follwing:

Inside of Excel, start recording a Macro (Tools->Macro->Record a Macro...), and do the things you want to do -- like Printing a range. Then, go and review the VBA code the macro made for you (ALT-F11). That VBA code will reveal the methods you can call on the various objects (Sheet, Application, etc.) to achieve your goal.

Here's the VBA code from a macro that prints a selected range:

    Range("A4:F20").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
[download]

And here's roughly (untested) what you might need to do to make it work with your Perl OLE objects:

    $Sheet->Range("A4:F20")->Select();
    $Excel->SelectedSheets->PrintOut({Copies=>1, Collate=>True});
[download]

Anyhow... something like that.

Good luck!

Kurt